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 votes125 views2 answers
Postgres download
SQL
-1 vote157 views1 answer
Mysql coalesce
SQL
0 vote144 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote138 views2 answers
Sql query inner join 3 tables
SQL
7 votes143 views2 answers
How to create index mysql
SQL
2 votes153 views1 answer
Sql string starts with
SQL
0 vote147 views1 answer
Get the Db column names from a SqlDataReader
SQL
6 votes141 views2 answers
Join vs union
SQL
2 votes139 views1 answer
Columns Present in a table
SQL
1 vote163 views1 answer
Mysql return text after a final full stop
SQL