• Home
• org.kuali.maven.impex
• jdbc-support
• 1.0.20
• source code
• drop.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

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