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!

Truncate all tables in database

800675Mar 29 2011 — edited Mar 29 2011
Hi All,

My requirement is to truncate all the tables in the database by just one single query without using PL\SQL just SQL.

Does any one have, any idea of how to do this...?

-Saransh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2011
Added on Mar 29 2011
7 comments
20,758 views