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!

Need single query for for deleting multiple statements

srikanth bJul 4 2022

In a database have some multiple tables requirement is to delete all the tables.For deletion need to run each delete statement. Any suggestions in a single statement?
DELETE FROM TBL1
DELETE FROM TBL2
DELETE FROM TBL3
,,
,,,
,,
DELETE FROM TBL80

This post has been answered by Stax on Jul 4 2022
Jump to Answer
Comments
Post Details
Added on Jul 4 2022
7 comments
611 views