Skip to Main Content
Forums

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!

Check if a table already exists?

725224Aug 10 2011 — edited Aug 10 2011
I need to check if a table exists and do the following; need help with writing query:

If table Exists then
delete * from the table
else
Create table

Edited by: user11146396 on Aug 10, 2011 1:14 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2011
Added on Aug 10 2011
6 comments
32,779 views