Database processing using DML statement

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?

only you know if it deletes the data you want

Quote:

---

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:

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