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
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
|
|
|