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