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('ROLLING'))
where gensby = 0
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('ROLLING'))
WHERE GENSBY = 0
|
|
|