VIEW: SYS.EXU8RFS

Source

View Text - Preformatted

SELECT  o$.obj#, o$.owner#, c$.property,
                DECODE(BITAND(c$.property, 1), 1, a$.name, c$.name),
                rf$.reftyp, NVL(rf$.stabid, HEXTORAW('00')),
                NVL2(rf$.stabid, (SELECT  ro$.obj#
                                  FROM    sys.obj$ ro$
                                  WHERE   ro$.oid$ = rf$.stabid),
                     0),
                DECODE(BITAND(rf$.reftyp, 4),
                       4, (SELECT  rcd$.con#
                           FROM    sys.obj$ ro$, sys.cdef$ rcd$
                           WHERE   ro$.oid$ = rf$.stabid AND
                                   rcd$.obj# = ro$.obj# AND
                                   rcd$.type# = 2),
                       0),
                DECODE(BITAND(rf$.reftyp, 4),
                       4, (SELECT  ru$.name
                           FROM    sys.obj$ ro$, sys.user$ ru$
                           WHERE   ro$.oid$ = rf$.stabid AND
                                   ru$.user# = ro$.owner#),
                       '')
        FROM    sys.refcon$ rf$, sys.obj$ o$, sys.col$ c$, sys.attrcol$ a$
        WHERE   rf$.obj# = o$.obj# AND
                rf$.obj# = c$.obj# AND
                rf$.intcol# = c$.intcol# AND
                rf$.obj# = a$.obj# (+) AND
                rf$.intcol# = a$.intcol# (+) AND
                rf$.reftyp != 0 AND
                BITAND(c$.property, 32768) != 32768     /* not unused column */

View Text - HTML Formatted

SELECT O$.OBJ#
, O$.OWNER#
, C$.PROPERTY
, DECODE(BITAND(C$.PROPERTY
, 1)
, 1
, A$.NAME
, C$.NAME)
, RF$.REFTYP
, NVL(RF$.STABID
, HEXTORAW('00'))
, NVL2(RF$.STABID
, (SELECT RO$.OBJ#
FROM SYS.OBJ$ RO$
WHERE RO$.OID$ = RF$.STABID)
, 0)
, DECODE(BITAND(RF$.REFTYP
, 4)
, 4
, (SELECT RCD$.CON#
FROM SYS.OBJ$ RO$
, SYS.CDEF$ RCD$
WHERE RO$.OID$ = RF$.STABID AND RCD$.OBJ# = RO$.OBJ# AND RCD$.TYPE# = 2)
, 0)
, DECODE(BITAND(RF$.REFTYP
, 4)
, 4
, (SELECT RU$.NAME
FROM SYS.OBJ$ RO$
, SYS.USER$ RU$
WHERE RO$.OID$ = RF$.STABID AND RU$.USER# = RO$.OWNER#)
, '')
FROM SYS.REFCON$ RF$
, SYS.OBJ$ O$
, SYS.COL$ C$
, SYS.ATTRCOL$ A$
WHERE RF$.OBJ# = O$.OBJ# AND RF$.OBJ# = C$.OBJ# AND RF$.INTCOL# = C$.INTCOL# AND RF$.OBJ# = A$.OBJ# (+) AND RF$.INTCOL# = A$.INTCOL# (+) AND RF$.REFTYP != 0 AND BITAND(C$.PROPERTY
, 32768) != 32768 /* NOT UNUSED COLUMN */