SELECT it."NAME",it."OBJID",it."OWNER",it."OWNERID"
FROM sys.exu81ity it, sys.incexp i, sys.incvid v
WHERE it.name = i.name(+) AND
it.ownerid = i.owner#(+) AND
NVL(i.type#, 32) = 32 AND
v.expid < NVL(i.expid, 9999)
SELECT IT."NAME"
, IT."OBJID"
, IT."OWNER"
, IT."OWNERID"
FROM SYS.EXU81ITY IT
, SYS.INCEXP I
, SYS.INCVID V
WHERE IT.NAME = I.NAME(+) AND
IT.OWNERID = I.OWNER#(+) AND
NVL(I.TYPE#
, 32) = 32 AND
V.EXPID < NVL(I.EXPID
, 9999)
|
|
|