DROP table <some table>;

In Oracle, The Complete Reference the examples for sqlplus to create a table start with:
drop table <the table to be created>;
create table <the table> ( ...

Now, I understand that the error is ignorable, but as a programmer it bothers me not to 1st check for the table's prior existence. So, how does one begin such a SQL script wherein the logic would be:

if (<the table to be created> exists) then drop table <the table>
end
create table ...

Reply by post and/or email at your preference. Thanks,

gary            The C Programmer's Reference:
         http://users.southeast.net/~garyg/C_ref/C/c.html
                AVENUE Class Requests Index:
           http://users.southeast.net/~garyg/class.htm