Need help for job implementation
Posted: Fri Nov 04, 2011 5:53 am
Hi All,
Need help to prepare job design for the below SQL query operation.
I cant use this query directly in Oracle Stage as the tables ABC and DEF are from different databases.
Please help me in how to develop the job for the same.
SELECT * FROM ABC WHERE (xxx,yyy,zzz) IN
(
SELECT xxx,yyy,zzz FROM ABC WHERE
STAT='DONE' AND FLAG=0 AND TRUNC((sysDate-STRTDATE) / 365) >= 2
MINUS
SELECT xxx,yyy,zzz FROM DEF WHERE LEVEL <> 1
)
Thanks in Advance,
Hema
Need help to prepare job design for the below SQL query operation.
I cant use this query directly in Oracle Stage as the tables ABC and DEF are from different databases.
Please help me in how to develop the job for the same.
SELECT * FROM ABC WHERE (xxx,yyy,zzz) IN
(
SELECT xxx,yyy,zzz FROM ABC WHERE
STAT='DONE' AND FLAG=0 AND TRUNC((sysDate-STRTDATE) / 365) >= 2
MINUS
SELECT xxx,yyy,zzz FROM DEF WHERE LEVEL <> 1
)
Thanks in Advance,
Hema