Script to Report Type Methods

Script to Report Type Methods

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;