◀ Previous

Slide 12.16: Data dictionary and objects Slide 13.1: Oracle PL/SQL Home         Print version

▶ Next

Data Dictionary and Objects (Cont.)

---

Listing Object Tables

view source print? 01 SQL> SELECT  table_name, table_type  FROM  user_object_tables; 02   03 TABLE_NAME                TABLE_TYPE 04 ------------------------- ------------------------- 05 ACCOUNTS                  ACC_TYP 06 ADDRESS_TAB               ADDRESS_TYP 07 CUSTOMER_TBL              CUSTOMER_TYP 08 EMP                       EMP_TYP 09 GAME_TBL                  GAME_TYP 10 PEOPLE_TBL                PERSON_T 11 PERSON                    PERSON_TYP 12 PERSON1                   PERSON_TYP 13 SCIENTISTS                NAME_T 14   15 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.

view source print? 01 SQL> SELECT  type_name, method_name  FROM  user_type_methods; 02   03 TYPE_NAME                      METHOD_NAME 04 ------------------------------ ------------------------------ 05 BOOK_TYP                       GET_DISCOUNT 06   07   08 SQL> SELECT  method_name, result_type_name  FROM  user_method_results; 09   10 METHOD_NAME                    RESULT_TYPE_NAME 11 ------------------------------ ------------------------------ 12 GET_DISCOUNT                   NUMBER

◀ Previous

Slide 12.16: Data dictionary and objects Slide 13.1: Oracle PL/SQL Home         Print version

▶ Next

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