How to find out if a table already exists with PL/SQL

Hi,

I'm porting a Sybase script to Oracle. There is this thing that we do in Sybase but I just can't do in Oracle. In Sybase, we do:

if exists (select * from sysobjects where name = 'TEMPTBL')  begin
 print "Deleting table TEMPTBL....."
 drop table TEMPTBL
 end
go

Just how do I do this in Oracle?

TIA Received on Thu Nov 09 2000 - 13:08:11 CST