Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Check user_types for just created types

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.