Oracle PL/SQL/Data Type/LOB

This script demonstrates user-defined LOBs (varray)

 

SQL> CREATE or REPLACE TYPE t1 AS VARRAY(3964) OF VARCHAR2(10);
  2  /

SQL> CREATE OR REPLACE TYPE t2 AS VARRAY(4001) OF VARCHAR2(10);
  2  /

SQL> CREATE OR REPLACE TYPE t3 AS VARRAY(3964) OF VARCHAR2(10);
  2  /
Type created.
SQL> CREATE TABLE myTable (
  2     column1   t1,
  3     column2   t2,
  4     column3   t3)
  5     VARRAY column3 STORE AS LOB column3_seg;
Table created.
SQL>
SQL>
SQL> drop table myTable;
Table dropped.