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!

DROP TABLE T1 IF EXISTS TABLE T1; ??

380441Dec 8 2003 — edited Dec 9 2003

Dear group,

I have a script which drops my tables. If the tables doent exist then there is an ugly (unprofessional) error in the sqlplus dialog.

I am sure I have seen sometime an ORACLE Script containing the statement similar to the one below, which could avoid this message.

DROP TABLE T1 IF EXISTS TABLE T1;

I have checked the SQLreference guide and I can not find any help for this. I would appreciate any help.

regards,

Ben Bookey

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2004

Added on Dec 8 2003

4 comments

418 views