Skip to Main Content

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!

list all the child/parents table in order ?

kaericnMay 3 2018 — edited May 4 2018

Greeting Dear Community,

We want to truncate all tables for a particular schema. How I can create an ordered list of the tables that need to be truncated.

My team lead asks me to walk through 70+ procedures to do this but I wonder there is a easier and cleaner way ?

Thanks for all the help.

This post has been answered by unknown-7404 on May 3 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2018
Added on May 3 2018
6 comments
461 views