This script provides documentation with respect to the different type methods in the database.
REM LOCATION: Object Management\Collection Reports
REM FUNCTION: Create a report of type methods
REM TESTED ON: 8.0.4.1, 8.1.5, 8.1.7, 9.0.1, 10.2.0.3, 11.1.0.6
REM PLATFORM: non-specific
REM REQUIRES: dba_type_methods
REM
REM
REM******************** Oracle Administration ********************
COLUMN owner FORMAT a10 HEADING 'Owner'
COLUMN type_name FORMAT a20 HEADING 'Type|Name'
COLUMN method_name FORMAT a20 HEADING 'Method|Name'
COLUMN method_type HEADING 'Method|Type'
COLUMN parameters FORMAT 99999 HEADING '#|Param'
COLUMN results FORMAT 99999 HEADING '#|Results'
COLUMN method_no FORMAT 999999 HEADING 'Meth.|Number'
BREAK ON owner ON type_name
SET LINES 80 PAGES 58 VERIFY OFF FEEDBACK OFF
ttitle 'Type Methods Report' skip 2
SELECT owner, type_name, method_name, method_no, method_type, PARAMETERS,
results
FROM dba_type_methods
ORDER BY owner, type_name;
