hi ,
I have 4 tables
1.table 1
2.table 2 ==> delete from here
3.table 3
4.table 4
table 2 & table 3 has pk_fk relationship
table 1 & table 4 ha spk_fk relationship
basically i wanted to do physical delete few rows from table 2 (Parent),
it should delete from child table rows to parent rows. ( since we have pk_fk relation ship)
I am looking gerneral way of deleting all those from child table rows to parent table rows.
Please help me to get advanced way of delete the rows.
---------- Post updated at 09:00 PM ---------- Previous update was at 08:58 PM ----------
i forgot to mention the software. I am looking oralce10g sql/ sql/plus solution.
thanks in advance.