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

0 vote209 views1 answer
Less mysql display
SQL
0 vote167 views1 answer
Oracle function select into
SQL
0 vote217 views1 answer
Cannot pip install mysqlclient
SQL
0 vote242 views1 answer
Transalations from sql to Linq count and group by
SQL
2 votes188 views1 answer
How to delete columns in sql
SQL
0 vote207 views1 answer
How to reset the database value in SQL server
SQL
0 vote227 views1 answer
Sqlcmd no headers
SQL
0 vote224 views1 answer
Sql waitfor
SQL
1 vote192 views1 answer
How to get mysql db size
SQL
12 votes192 views2 answers
Delete all data in neo4j
SQL