Programming

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.