Java Database Connectivity (JDBC)

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 and create table in oracle

843854May 17 2004 — edited Nov 20 2014

Hi,

How do I execute these queries in Oracle 9i?

create table if not exists table_name (val int);
drop table if exists table_name;

They give "ORA-00922: missing or invalid option" and "ORA-00933: SQL command not properly ended" errors respectively.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2009

Added on May 17 2004

#database-connectivity-discussions

10 comments

2,205 views