VIEW: SYS.KU$_PKREF_CONSTRAINT_VIEW

Source

View Text - Preformatted

select rf.obj#, rf.col#, rf.intcol#, rf.reftyp, c.property, c.name,
        (select a.name from attrcol$ a
                 where a.obj#=rf.obj# and a.intcol#=rf.intcol#),
        (select value(o) from ku$_schemaobj_view o, obj$ oo
                 where rf.stabid = oo.oid$
                    and oo.obj#  = o.obj_num),
        nvl((select 1
             from coltype$ fct, ccol$ fcc, cdef$ fcd
             where fct.obj# = rf.obj# and
                   fct.intcol# = rf.intcol# and
                   fcc.obj# = rf.obj# and
                   fcc.intcol# =
                     UTL_RAW.CAST_TO_BINARY_INTEGER(
                       SUBSTRB(fct.intcol#s, 1, 2), 3) and
                   fcd.con# = fcc.con# and
                   fcd.type# = 4), 0),
        decode(bitand(rf.reftyp,4),
                       4, cast(multiset
                                (select rc.*
                                 from   ku$_simple_col_view rc, ccol$ rcc
                                 where  rcc.con# =
                                            (select con#
                                             from   obj$ ro, cdef$ rcd
                                             where  ro.oid$ = rf.stabid and
                                                    rcd.obj# = ro.obj# and
                                                    rcd.type# = 2)       and
                                          rc.obj_num = rcc.obj# and
                                          rc.intcol_num = rcc.intcol#
                                  order by rcc.pos#
                                ) as ku$_simple_col_list_t),
                       null)
 from refcon$ rf, col$ c
 where c.obj#=rf.obj# and c.intcol#=rf.intcol#

View Text - HTML Formatted

SELECT RF.OBJ#
, RF.COL#
, RF.INTCOL#
, RF.REFTYP
, C.PROPERTY
, C.NAME
, (SELECT A.NAME
FROM ATTRCOL$ A
WHERE A.OBJ#=RF.OBJ#
AND A.INTCOL#=RF.INTCOL#)
, (SELECT VALUE(O)
FROM KU$_SCHEMAOBJ_VIEW O
, OBJ$ OO
WHERE RF.STABID = OO.OID$
AND OO.OBJ# = O.OBJ_NUM)
, NVL((SELECT 1
FROM COLTYPE$ FCT
, CCOL$ FCC
, CDEF$ FCD
WHERE FCT.OBJ# = RF.OBJ# AND FCT.INTCOL# = RF.INTCOL# AND FCC.OBJ# = RF.OBJ# AND FCC.INTCOL# = UTL_RAW.CAST_TO_BINARY_INTEGER( SUBSTRB(FCT.INTCOL#S
, 1
, 2)
, 3) AND FCD.CON# = FCC.CON# AND FCD.TYPE# = 4)
, 0)
, DECODE(BITAND(RF.REFTYP
, 4)
, 4
, CAST(MULTISET (SELECT RC.*
FROM KU$_SIMPLE_COL_VIEW RC
, CCOL$ RCC
WHERE RCC.CON# = (SELECT CON#
FROM OBJ$ RO
, CDEF$ RCD
WHERE RO.OID$ = RF.STABID AND RCD.OBJ# = RO.OBJ# AND RCD.TYPE# = 2) AND RC.OBJ_NUM = RCC.OBJ# AND RC.INTCOL_NUM = RCC.INTCOL# ORDER BY RCC.POS# ) AS KU$_SIMPLE_COL_LIST_T)
, NULL)
FROM REFCON$ RF
, COL$ C
WHERE C.OBJ#=RF.OBJ#
AND C.INTCOL#=RF.INTCOL#