Script to Report Database Types

Script to Report Database Types

This script provides documentation with respect to the different collection types in the database.

REM LOCATION:   Object Management\Collections

REM FUNCTION:   Provide basic report of all database types

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_types

REM

REM

REM********************  Oracle Administration ********************

COLUMN owner         FORMAT a10     HEADING 'Type|Owner'

COLUMN type_name     FORMAT a30     HEADING 'Type|Name'

COLUMN typecode      FORMAT a27     HEADING 'Type|Code'

COLUMN predefined    FORMAT a11     HEADING 'Predefined?'

COLUMN incomplete    FORMAT a11     HEADING 'Incomplete?'

COLUMN methods       FORMAT 9999999 HEADING '#|Methods'

COLUMN attributes    FORMAT 999999  HEADING '#|Attrib'

SET LINES 130 PAGES 58 VERIFY OFF FEEDBACK OFF

BREAK ON owner

ttitle 'Database Types Report' skip 2

SELECT   DECODE (owner, NULL, 'SYS-GEN', owner) owner, type_name, typecode,

         ATTRIBUTES, methods, predefined, incomplete

    FROM dba_types

ORDER BY owner, type_name;