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

From: NoSpam <NoSpam_at_NoSpam.com>
Date: Thu, 9 Nov 2000 14:08:11 -0500
Message-ID: <8uekvs$ibi$1_at_ih292.ea.unisys.com>


Hi,

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

[Quoted] 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 - 20:08:11 CET

Original text of this message