IF Exists SQL statement help

In Microsoft sequal server I have this statement:

if exists (select * from dbo.sysobjects where id = object_id('[my_table]') and OBJECTPROPERTY(id,'IsUserTable') = 1) DROP TABLE [my_table]
GO

this obviously checks to see if a table exists before executing the drop table statement.

what would the Oracle equivalent of this be?

Thanks from an Oracle newbie! Received on Fri Aug 23 2002 - 05:28:06 CDT