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

3 votes120 views3 answers
C# sql select
SQL
0 vote152 views1 answer
Table structure in sql
SQL
13 votes129 views3 answers
Insert mysql ifile nto database
SQL
0 vote113 views1 answer
Subquery aggregation
SQL
2 votes120 views1 answer
Oracle drop table free up space
SQL
0 vote119 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote121 views1 answer
Big table in mysql
SQL
0 vote114 views1 answer
Shrink database file in sql server
SQL
0 vote126 views1 answer
Sqlite unique multiple columns
SQL
18 votes114 views6 answers
Create table mysql
SQL