Oracle PL/SQL/System Tables Views/user types

Check user_types for just created types

   <source lang="sql">
  

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.

 </source>