SELECT sname, oname,
DECODE (type, -1, 'SNAPSHOT',
1, 'INDEX',
2, 'TABLE',
4, 'VIEW',
5, 'SYNONYM',
6, 'SEQUENCE',
7, 'PROCEDURE',
8, 'FUNCTION',
9, 'PACKAGE',
11, 'PACKAGE BODY',
12, 'TRIGGER',
-4, 'INTERNAL PACKAGE',
--- -3, 'UPDATABLE SNAPSHOT',
13, 'TYPE',
14, 'TYPE BODY',
32, 'INDEXTYPE',
33, 'OPERATOR',
'UNDEFINED'),
DECODE (status, 0, 'CREATE',
1, 'COMPARE',
2, 'VALID',
3, 'DROPPED',
4, 'ERROR',
5, 'ABSENT',
6, 'INCOMPLETE',
'UNDEFINED'),
DECODE (DECODE (gentrigger, NULL, genpackage, gentrigger * 3 +
genpackage),
0, 'GENERATED', -- 0, 0
1, 'NEEDSGEN', -- 0, 1
2, 'DOINGGEN', -- 0, 2
3, 'NEEDSGEN', -- 1, 0
4, 'NEEDSGEN', -- 1, 1
5, 'DOINGGEN', -- 1, 2
6, 'DOINGGEN', -- 2, 0
7, 'DOINGGEN', -- 2, 1
8, 'DOINGGEN'), -- 2, 2
id, object_comment, gowner, gname,
DECODE(o.type,
2, DECODE(bitand(t.trigflag, 1), 1, 'Y', 'N'),
-1, DECODE(bitand(t.trigflag, 1), 1, 'Y', 'N'),
NULL),
DECODE(o.type,
-1, DECODE(utl_raw.bit_and(utl_raw.substr(o.flag, 1, 1), '01'),
'00', 'N',
'Y'),
2, DECODE(utl_raw.bit_and(utl_raw.substr(o.flag, 1, 1), '01'),
'00', 'N',
'Y'),
NULL),
DECODE(o.type,
2, DECODE(utl_raw.bit_and(utl_raw.substr(o.flag, 1, 1), '04'),
'00', 'N',
'Y'),
-1, DECODE(utl_raw.bit_and(utl_raw.substr(o.flag, 1, 1), '04'),
'00', 'N',
'Y'),
NULL),
DECODE(o.type,
2, DECODE(utl_raw.bit_and(utl_raw.substr(o.flag, 1, 1), '10'),
'00', 'N',
'Y'),
9, DECODE(utl_raw.bit_and(utl_raw.substr(o.flag, 1, 1), '10'),
'00', 'N',
'Y'),
-1, DECODE(utl_raw.bit_and(utl_raw.substr(o.flag, 1, 1), '10'),
'00', 'N',
'Y'),
NULL),
DECODE(bitand(t.property, 8192), 8192, 'Y', 0, 'N'),
RAWTOHEX(o.hashcode)
FROM system.repcat$_repobject o, sys.tab$ t
WHERE o.id = t.obj# (+)
SELECT SNAME
, ONAME
,
DECODE (TYPE
, -1
, 'SNAPSHOT'
,
1
, 'INDEX'
,
2
, 'TABLE'
,
4
, 'VIEW'
,
5
, 'SYNONYM'
,
6
, 'SEQUENCE'
,
7
, 'PROCEDURE'
,
8
, 'FUNCTION'
,
9
, 'PACKAGE'
,
11
, 'PACKAGE BODY'
,
12
, 'TRIGGER'
,
-4
, 'INTERNAL PACKAGE'
,
--- -3
, 'UPDATABLE SNAPSHOT'
,
13
, 'TYPE'
,
14
, 'TYPE BODY'
,
32
, 'INDEXTYPE'
,
33
, 'OPERATOR'
,
'UNDEFINED')
,
DECODE (STATUS
, 0
, 'CREATE'
,
1
, 'COMPARE'
,
2
, 'VALID'
,
3
, 'DROPPED'
,
4
, 'ERROR'
,
5
, 'ABSENT'
,
6
, 'INCOMPLETE'
,
'UNDEFINED')
,
DECODE (DECODE (GENTRIGGER
, NULL
, GENPACKAGE
, GENTRIGGER * 3 +
GENPACKAGE)
,
0
, 'GENERATED'
, -- 0
, 0
1
, 'NEEDSGEN'
, -- 0
, 1
2
, 'DOINGGEN'
, -- 0
, 2
3
, 'NEEDSGEN'
, -- 1
, 0
4
, 'NEEDSGEN'
, -- 1
, 1
5
, 'DOINGGEN'
, -- 1
, 2
6
, 'DOINGGEN'
, -- 2
, 0
7
, 'DOINGGEN'
, -- 2
, 1
8
, 'DOINGGEN')
, -- 2
, 2
ID
, OBJECT_COMMENT
, GOWNER
, GNAME
,
DECODE(O.TYPE
,
2
, DECODE(BITAND(T.TRIGFLAG
, 1)
, 1
, 'Y'
, 'N')
,
-1
, DECODE(BITAND(T.TRIGFLAG
, 1)
, 1
, 'Y'
, 'N')
,
NULL)
,
DECODE(O.TYPE
,
-1
, DECODE(UTL_RAW.BIT_AND(UTL_RAW.SUBSTR(O.FLAG
, 1
, 1)
, '01')
,
'00'
, 'N'
,
'Y')
,
2
, DECODE(UTL_RAW.BIT_AND(UTL_RAW.SUBSTR(O.FLAG
, 1
, 1)
, '01')
,
'00'
, 'N'
,
'Y')
,
NULL)
,
DECODE(O.TYPE
,
2
, DECODE(UTL_RAW.BIT_AND(UTL_RAW.SUBSTR(O.FLAG
, 1
, 1)
, '04')
,
'00'
, 'N'
,
'Y')
,
-1
, DECODE(UTL_RAW.BIT_AND(UTL_RAW.SUBSTR(O.FLAG
, 1
, 1)
, '04')
,
'00'
, 'N'
,
'Y')
,
NULL)
,
DECODE(O.TYPE
,
2
, DECODE(UTL_RAW.BIT_AND(UTL_RAW.SUBSTR(O.FLAG
, 1
, 1)
, '10')
,
'00'
, 'N'
,
'Y')
,
9
, DECODE(UTL_RAW.BIT_AND(UTL_RAW.SUBSTR(O.FLAG
, 1
, 1)
, '10')
,
'00'
, 'N'
,
'Y')
,
-1
, DECODE(UTL_RAW.BIT_AND(UTL_RAW.SUBSTR(O.FLAG
, 1
, 1)
, '10')
,
'00'
, 'N'
,
'Y')
,
NULL)
,
DECODE(BITAND(T.PROPERTY
, 8192)
, 8192
, 'Y'
, 0
, 'N')
,
RAWTOHEX(O.HASHCODE)
FROM SYSTEM.REPCAT$_REPOBJECT O
, SYS.TAB$ T
WHERE O.ID = T.OBJ# (+)
|
|
|