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>
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