Delete rows from multiple tables
711834Nov 17 2009 — edited Nov 17 2009Hi There,
I have a schema of around 700 tables within our Oracle db. There is a group of about 20 tables that i need to delete a provider from.
A provider is added to the provider_tbl, and issuesd a prrovider_id (PK), they can then also be added to multiple other tables, once say a contact ddress is entered (address_tbl).
I have the PK/FK relationships, my issues is how to structure a script to look through each of the cascading tables...
Apologies, but i am just staring out with PL/SQL. I have eperience with VBA, using that i would do a COUNT and use a FOR NEXT LOOP to take the cursor through and delete....
Thanks in advance,
Patrick