Database processing using DML statement

[tamilselvan]

DELETE FROM J63 a WHERE ticketid IN ( SELECT c1 FROM K63 b
WHERE a.ticketid=b.c1 and integerdate ( c3 ) < add_months( sysdate, -36 ))

IN subquery does not need join with the outer query.

You can change the code:

DELETE FROM J63 a 
WHERE exists 
        ( SELECT 'x' FROM K63 b
         WHERE a.ticketid=b.c1 and 
                   integerdate ( c3 ) < add_months( sysdate, -36 )
        )

Tamil
www.oracleact.com