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




      I was banging my head against the wall (feeling angry or annoyed)    
      trying to lose weight without exercising.