DBA Data[Home] [Help]

VIEW: SYS.EXU8CCLO

Source

View Text - Preformatted

SELECT  a.ownerid, a.cno, a.colname, a.colno, a.property
        FROM    sys.exu8ccl a, sys.con$ b , sys.cdef$ c
        WHERE   b.owner# = userenv('SCHEMAID') AND
                b.con# = c.con# AND
                c.rcon# = a.cno
View Text - HTML Formatted

SELECT A.OWNERID
, A.CNO
, A.COLNAME
, A.COLNO
, A.PROPERTY
FROM SYS.EXU8CCL A
, SYS.CON$ B
, SYS.CDEF$ C
WHERE B.OWNER# = USERENV('SCHEMAID') AND B.CON# = C.CON# AND C.RCON# = A.CNO