Varray of user types : Varray « Object Oriented Database « Oracle PL / SQL






Varray of user types

 
SQL>
SQL>
SQL> create or replace type erratum_t as object
  2  ( code varchar2(4)
  3  , ch   number(2)
  4  , pg   number(3)
  5  , txt  varchar2(40)
  6  ) ;
  7  /

Type created.

SQL>
SQL> create or replace type errata_tab_t as table of erratum_t;
  2  /

Type created.

SQL>
SQL> describe errata_tab_t
 errata_tab_t TABLE OF ERRATUM_T
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 CODE                                               VARCHAR2(4)
 CH                                                 NUMBER(2)
 PG                                                 NUMBER(3)
 TXT                                                VARCHAR2(40)

SQL> drop type errata_tab_t force;

Type dropped.

SQL> drop type erratum_t    force;

Type dropped.

SQL>

   
  








Related examples in the same category

1.DML operations on collections.