|
SQL>
SQL>
SQL> create or replace type numberlist_t
2 as varray(4) of varchar2(20);
3 /
Type created.
SQL>
SQL> describe numberlist_t
numberlist_t VARRAY(4) OF VARCHAR2(20)
SQL>
SQL> select type_name, typecode
2 from user_types;
Enter...
OBJECTELEM OBJECT
SQLMONTH_TABLETYPE COLLECTION
ORD_TYPE OBJECT
ORD_TABLE COLLECTION
ADDRESS_TYP OBJECT
VARRAY_PHONE_TYP COLLECTION
NESTED_TABLE_ADDRESS_TYP COLLECTION
VARRAY_ADDRESS_TYP COLLECTION
VCARRAY COLLECTION
CUSTOMER_TY OBJECT
MYSCALARTYPE OBJECT
PERSON_TYPE OBJECT
NUMBERLIST_T COLLECTION
ADDRESS_TYPE OBJECT
DATE_LIST COLLECTION
STOLEN_ITEMS OBJECT
STATS_LINE OBJECT
STATS_ARRAY COLLECTION
RUN_STATS_OUTPUT OBJECT
REC_LIST COLLECTION
REC OBJECT
Enter... drop type numberlist_t force;
EMP2REC OBJECT
EMP2LIST COLLECTION
NUM_LIST COLLECTION
ADDRESS_RECORD OBJECT
INDIVIDUAL_RECORD OBJECT
INTEGER_VARRAY COLLECTION
INDIVIDUAL_ADDRESS_RECORD OBJECT
VARRAY_NESTED_TABLE COLLECTION
T1 OBJECT
T2 OBJECT
ORACLEERROR OBJECT
DISCOUNT_PRICE_OBJ OBJECT
BOOK_OBJ OBJECT
MUSIC_PERSON_OBJ OBJECT
MUSIC_OBJ OBJECT
CD_OBJ OBJECT
INVENTORY_OBJ OBJECT
ADDRESS_OBJ OBJECT
PERSON_OBJ OBJECT
CONTACT_OBJ OBJECT
PUBLISHER_OBJ OBJECT
Enter...
ABBREV_INVENTORY_OBJ OBJECT
ABBREV_BOOK_OBJ OBJECT
VARRAY_LOB_OBJ COLLECTION
VARRAY_LOB2_OBJ COLLECTION
VARRAY_TABLE_OBJ COLLECTION
VARCHAR2_TYPE COLLECTION
BUILD_TEST OBJECT
NAME_OBJECT OBJECT
CONTACT_OBJECT OBJECT
PERSON_TABLE COLLECTION
PERSONS COLLECTION
PERSON_TABLE_T COLLECTION
FILM_T OBJECT
EMPLOYEE_T OBJECT
STUDENT_T OBJECT
BOOK_TYPE OBJECT
FILM_TABLE_T COLLECTION
DIRECTOR_T OBJECT
STAFF_T OBJECT
MANAGER_T OBJECT
WORKER_T OBJECT
Enter...
CUSTOMER_T OBJECT
LIST COLLECTION
CUSTOMERTYPE OBJECT
DATETABLETYPE COLLECTION
GIFT_TYPE OBJECT
UNITTYPE COLLECTION
CARD_UNIT_VARRAY COLLECTION
CARD_SUIT_VARRAY COLLECTION
CARD_DECK_TABLE COLLECTION
EMPTYPE OBJECT
CATEGORYTYPE COLLECTION
GIFT_TABLE COLLECTION
CHARARRAYTYPE COLLECTION
76 rows selected.
|