Oracle PL/SQL/Data Type/LOB

This script demonstrates user-defined LOBs (varray)

   <source lang="sql">

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.

 </source>