Database processing using DML statement

[dbajay]

I wish to remove all the concern records from J63 tables matchs similarly with K63 tables on the basis of comumn column c1 and ticketid.

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

integerdate is a function name.

Can you suggest me whether it is correct or not?

Is there any better way to remove records quickly like join options?

[davey23uk]

only you know if it deletes the data you want

[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