drop table if exists oracle

Solutions on MaxInterview for drop table if exists oracle by the best coders in the world

Search
showing results for - "drop table if exists oracle"
Raymond
17 Feb 2019
1DECLARE
2    existing_table number;
3BEGIN
4    SELECT count(*) into existing_table FROM ALL_TABLES
5    WHERE TABLE_NAME = 'table_name' AND OWNER = 'owner';
6    IF existing_table = 1 then
7        EXECUTE IMMEDIATE 'DROP TABLE owner.table_name';
8    END IF;
9END;
10/
11CREATE TABLE owner.table_name (BDAY DATE, [...]);
similar questions
pl sql delete from tableoracle create table if not existsdelete all table oracleoracle drop rulespl sql trigger determine if insert or update or deleteoracle drop sequence if existscheck if table exists oracleplsql code for deleting a row from nested table in oraclesql drop view if existssql drop table if existsoracle drop constraintoracle drop type if existssql server drop table if existsoracle drop columnoracle drop job if existsdelete column from table oracle pl sqloracle drop index if existsoracle drop temporary tableoracle sql drop column if existsoracle drop all schema tablesdrop table if existsoracle sql drop table purgedrop table if exists testtable drop if exist sql serverdelete rows table oracleoracle sql drop table
queries leading to this page
drop table if exists oracleoracle drop table if existsdrop table if exists sql oracledrop table if exists oracle