Oracle PL/SQL Tutorial/System Tables Data Dictionary/user types

30. Query user_types

   <source lang="sql">

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 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></source>