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

7 votes290 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
37 votes309 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote287 views1 answer
Add column to table with default value plsql
SQL
0 vote290 views1 answer
Postgresql default value boolean
SQL
1 vote307 views1 answer
Sql server insert into temp table
SQL
0 vote323 views1 answer
How to check database engine in mysql
SQL
5 votes293 views1 answer
Sql check if date is between 2 dates
SQL
1 vote298 views1 answer
Rename table column name in mysql
SQL
0 vote328 views1 answer
Cube oracle
SQL
0 vote291 views1 answer
Alter table fulltext
SQL