VIEW: SYS.DBA_LOGSTDBY_UNSUPPORTED

Source

View Text - Preformatted

select owner, table_name, column_name, attributes,
  substr(decode(type#, 1, decode(charsetform, 2, 'NVARCHAR2', 'VARCHAR2'),
                2, decode(scale, null, decode(precision#, null,
                          'NUMBER', 'FLOAT'), 'NUMBER'),
                8, 'LONG',
                9, decode(charsetform, 2, 'NCHAR VARYING', 'VARCHAR'),
                12, 'DATE',
                23, 'RAW',
                24, 'LONG RAW',
                58, 'OPAQUE',
                69, 'ROWID',
                96, decode(charsetform, 2, 'NCHAR', 'CHAR'),
                100, 'BINARY_FLOAT',
                101, 'BINARY_DOUBLE',
                105, 'MLSLABEL',
                106, 'MLSLABEL',
                110, 'REF',
                111, 'REF',
                112, decode(charsetform, 2, 'NCLOB', 'CLOB'),
                113, 'BLOB',
                114, 'BFILE',
                115, 'CFILE',
                121, 'OBJECT',
                122, 'NESTED TABLE',
                123, 'VARRAY',
                178, 'TIME(' ||scale|| ')',
                179, 'TIME(' ||scale|| ')' || ' WITH TIME ZONE',
                180, 'TIMESTAMP(' ||scale|| ')',
                181, 'TIMESTAMP(' ||scale|| ')' || ' WITH TIME ZONE',
                231, 'TIMESTAMP(' ||scale|| ')' || ' WITH LOCAL TIME ZONE',
                182, 'INTERVAL YEAR(' ||precision#||') TO MONTH',
                183, 'INTERVAL DAY(' ||precision#||') TO SECOND('
                                     || scale || ')',
                208, 'UROWID',
                'UNDEFINED'),1,32) data_type
  from table (logstdby$utabf('LOGSTDBY'))
  where gensby = 0

View Text - HTML Formatted

SELECT OWNER
, TABLE_NAME
, COLUMN_NAME
, ATTRIBUTES
, SUBSTR(DECODE(TYPE#
, 1
, DECODE(CHARSETFORM
, 2
, 'NVARCHAR2'
, 'VARCHAR2')
, 2
, DECODE(SCALE
, NULL
, DECODE(PRECISION#
, NULL
, 'NUMBER'
, 'FLOAT')
, 'NUMBER')
, 8
, 'LONG'
, 9
, DECODE(CHARSETFORM
, 2
, 'NCHAR VARYING'
, 'VARCHAR')
, 12
, 'DATE'
, 23
, 'RAW'
, 24
, 'LONG RAW'
, 58
, 'OPAQUE'
, 69
, 'ROWID'
, 96
, DECODE(CHARSETFORM
, 2
, 'NCHAR'
, 'CHAR')
, 100
, 'BINARY_FLOAT'
, 101
, 'BINARY_DOUBLE'
, 105
, 'MLSLABEL'
, 106
, 'MLSLABEL'
, 110
, 'REF'
, 111
, 'REF'
, 112
, DECODE(CHARSETFORM
, 2
, 'NCLOB'
, 'CLOB')
, 113
, 'BLOB'
, 114
, 'BFILE'
, 115
, 'CFILE'
, 121
, 'OBJECT'
, 122
, 'NESTED TABLE'
, 123
, 'VARRAY'
, 178
, 'TIME(' ||SCALE|| ')'
, 179
, 'TIME(' ||SCALE|| ')' || ' WITH TIME ZONE'
, 180
, 'TIMESTAMP(' ||SCALE|| ')'
, 181
, 'TIMESTAMP(' ||SCALE|| ')' || ' WITH TIME ZONE'
, 231
, 'TIMESTAMP(' ||SCALE|| ')' || ' WITH LOCAL TIME ZONE'
, 182
, 'INTERVAL YEAR(' ||PRECISION#||') TO MONTH'
, 183
, 'INTERVAL DAY(' ||PRECISION#||') TO SECOND(' || SCALE || ')'
, 208
, 'UROWID'
, 'UNDEFINED')
, 1
, 32) DATA_TYPE
FROM TABLE (LOGSTDBY$UTABF('LOGSTDBY'))
WHERE GENSBY = 0