Data Dictionary and Objects (Cont.)


Listing Object Tables

01SQL> SELECT  table_name, table_type  FROM  user_object_tables;
02 
03TABLE_NAME                TABLE_TYPE
04------------------------- -------------------------
05ACCOUNTS                  ACC_TYP
06ADDRESS_TAB               ADDRESS_TYP
07CUSTOMER_TBL              CUSTOMER_TYP
08EMP                       EMP_TYP
09GAME_TBL                  GAME_TYP
10PEOPLE_TBL                PERSON_T
11PERSON                    PERSON_TYP
12PERSON1                   PERSON_TYP
13SCIENTISTS                NAME_T
14 
159 rows selected.


Obtaining Descriptions of Object Type Methods
Information about object type methods can be found in the data dictionary.
01SQL> SELECT  type_name, method_name  FROM  user_type_methods;
02 
03TYPE_NAME                      METHOD_NAME
04------------------------------ ------------------------------
05BOOK_TYP                       GET_DISCOUNT
06 
07 
08SQL> SELECT  method_name, result_type_name  FROM  user_method_results;
09 
10METHOD_NAME                    RESULT_TYPE_NAME
11------------------------------ ------------------------------
12GET_DISCOUNT                   NUMBER




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