org.kuali.db.oracle.drop.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of jdbc-support Show documentation

Various utility methods for JDBC

There is a newer version: 1.1.3

-- Drop the user and ignore the Oracle 'user does not exist' error
-- Dropping the user removes all objects associated with this schema (tables, views, indexes, sequences, etc)
-- This is roughly the equivalent to MySQL's: DROP DATABASE [databaseName] IF EXISTS
BEGIN 
  EXECUTE IMMEDIATE 'DROP USER ${database} CASCADE'; 
EXCEPTION WHEN OTHERS THEN 
 IF SQLCODE != ${oracle.error.sqlcode.userDoesNotExist} THEN
   RAISE;
 END IF;
END;
/