Oracle PL/SQL Tutorial/Object Oriented/Drop Type
Drop a type
<source lang="sql">
SQL> SQL> SQL> create or replace type address_type as object
2 ( city varchar2(30), 3 street varchar2(30), 4 state varchar2(2), 5 zip number 6 ) 7 /
Type created. SQL> SQL> drop type address_type; Type dropped.</source>
drop type force
<source lang="sql">
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>