SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

to find the tables which is having link with particular table.

850050May 10 2012 — edited May 10 2012

hi all,
i am working on db 10g.
i have table called JOB_HEADER
My task is to delete the data in the job_header table.
Before doing this task, i want to know which are the tables referencing this particular table.
in other words i have to delelete child records first then i have to delete the above said table.
is there any way to know the child table existance for this particular parent table?

Thanks..

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2012

Added on May 10 2012

#dba, #query, #sql-developer, #table

6 comments

562 views