Mega Code Archive

 

Categories / Oracle PLSQL / Object Oriented Database

 

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>