How to check if a database objects exist before creating a new one in Oracle?
Is there any similar sql statement in Oracle just like one below in SQL Server?
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BU_STATE]') and OBJECTPROPERTY(id, N'IsTable') = 1)
drop table [dbo].[BU_STATE]
If so then please advise.
Basically, I like to run a sql statement to drop a table or any database objects (for example function, procedure, view, package) if it exists in Oracle Database. If database objects do not exist then sql statement will run without any error.