Drop table if exists oracle

DECLARE
    existing_table number;
BEGIN
    SELECT count(*) into existing_table FROM ALL_TABLES
    WHERE TABLE_NAME = 'table_name' AND OWNER = 'owner';
    IF existing_table = 1 then
        EXECUTE IMMEDIATE 'DROP TABLE owner.table_name';
    END IF;
END;
/
CREATE TABLE owner.table_name (BDAY DATE, [...]);

Similar codes

4 votes399 views6 answers
Select sql
SQL
0 vote345 views1 answer
Soql user profile
SQL
1 vote332 views2 answers
Mysql does sentance contain word
SQL
0 vote333 views1 answer
Replace sqlalchemy
SQL
0 vote342 views1 answer
Select value from previous row in postgresql
SQL
5 votes371 views2 answers
Postgresql add not null constraint
SQL
1 vote359 views2 answers
Sql now - 1 day
SQL
0 vote342 views1 answer
Object Information
SQL
11 votes362 views2 answers
Insert current date sql
SQL
0 vote392 views2 answers
Coursera spark sql max count
SQL