Slide 12.17: Data dictionary and objects (cont.)

Data Dictionary and Objects (Cont.)

Listing Object Tables

 SQL> SELECT  table_name, table_type  FROM  user_object_tables;

TABLE_NAME                TABLE_TYPE
------------------------- -------------------------
ACCOUNTS                  ACC_TYP
ADDRESS_TAB               ADDRESS_TYP
CUSTOMER_TBL              CUSTOMER_TYP
EMP                       EMP_TYP
GAME_TBL                  GAME_TYP
PEOPLE_TBL                PERSON_T
PERSON                    PERSON_TYP
PERSON1                   PERSON_TYP
SCIENTISTS                NAME_T

9 rows selected.

Obtaining Descriptions of Object Type Methods
Information about object type methods can be found in the data dictionary.

%_METHOD_PARAMS: Describes the method parameters of types owned by or accessible to the user.
%_METHOD_RESULTS: Describes the method results of types owned by or accessible to the user.
%_TYPE_METHODS: Describes the methods of types owned by or accessible to the user.

 SQL> SELECT  type_name, method_name  FROM  user_type_methods;

 TYPE_NAME                      METHOD_NAME
 ------------------------------ ------------------------------
 BOOK_TYP                       GET_DISCOUNT


 SQL> SELECT  method_name, result_type_name  FROM  user_method_results;

 METHOD_NAME                    RESULT_TYPE_NAME
 ------------------------------ ------------------------------
 GET_DISCOUNT                   NUMBER