SQL Language (MOSC)

MOSC Banner

Parent and child table relationships

edited Apr 23, 2012 2:14AM in SQL Language (MOSC) 8 comments
Hi ,       I have list of four tables and I want to delete data from those tables. There are child tables under it and  I see  more child tables under those in hierarchy.
 
There are two methods to  delete the data either delete the data from all child tables in  hierarchy or disable the foreign keys.
 
I don't want to disable the foreign keys but I am trying to delete the data from child tables  however the child tables have FK...so It will not allow to delete from child table.

Is their a query that will list all the child table relationships on those four parent tables in  hierarchy and from from where I should start the delete.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center