Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Object Oriented

 

Describe a type

SQL> SQL> create or replace type numberVarray as varray(4) of varchar2(20);   2  / Type created. SQL> SQL> describe numberVarray  numberVarray VARRAY(4) OF VARCHAR2(20) SQL> SQL> select type_name, typecode   2  from   user_types; TYPE_NAME                      TYPECODE ------------------------------ ------------------------------ DEBUG_O                        OBJECT NUMBERLIST_T                   COLLECTION ADDRESS2                       OBJECT ZIP_CODE                       OBJECT NUM_VARRAY                     COLLECTION NUM_TABLE                      COLLECTION ADD_LIST                       COLLECTION HOME_ADD_LIST                  COLLECTION SYS_PLSQL_14797_54_1           COLLECTION SYS_PLSQL_14797_DUMMY_1        COLLECTION SYS_PLSQL_14797_9_1            OBJECT VCARRAY                        COLLECTION STRINGS_NT                     COLLECTION RIVER                          OBJECT WATERFALL                      OBJECT SQLMONTH_TABLETYPE             COLLECTION ORD_TYPE                       OBJECT ORD_TABLE                      COLLECTION DTARRAY                        COLLECTION TYPE_NAME                      TYPECODE ------------------------------ ------------------------------ NMARRAY                        COLLECTION EMP_T                          OBJECT ASCII_TABLE_TYPE               OBJECT PHONE_NUM_REC_TYPE             OBJECT NUMBERVARRAY                   COLLECTION 24 rows selected. SQL> SQL> drop type numberVarray force; Type dropped. SQL>