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.
Related examples in the same category