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!

truncating multiple tables with single query

dprogrammerxJun 1 2009 — edited Mar 7 2013

Hi, I have about 12 tables that contain inter-related data, i-e with foreign key relationships. Is it possible to truncate all tables at once, kind of CASCADE delete, with one query?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2013

Added on Jun 1 2009

11 comments

38,903 views