This script demonstrates user-defined LOBs (varray) : LOB « Data Type « Oracle PL / SQL






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