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