SELECT s."LOG_OWNER",s."LOG_OWNERID",s."MASTER",s."LOG_TABLE",s."LOG_TRIGGER" from exu7snapl s, incexp i, incvid v
WHERE s.master = i.name(+) AND s.log_ownerid = i.owner#(+) AND
NVL(i.type#,-3) = -3 AND
(NVL(i.ctime,TO_DATE('01-01-1900','DD-MM-YYYY')) < i.itime OR
NVL(i.expid,9999) > v.expid)
SELECT S."LOG_OWNER"
, S."LOG_OWNERID"
, S."MASTER"
, S."LOG_TABLE"
, S."LOG_TRIGGER"
FROM EXU7SNAPL S
, INCEXP I
, INCVID V
WHERE S.MASTER = I.NAME(+)
AND S.LOG_OWNERID = I.OWNER#(+) AND
NVL(I.TYPE#
, -3) = -3 AND
(NVL(I.CTIME
, TO_DATE('01-01-1900'
, 'DD-MM-YYYY')) < I.ITIME OR
NVL(I.EXPID
, 9999) > V.EXPID)
|
|
|