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 vote212 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote245 views1 answer
Eliminate zero from integer mysql
SQL
0 vote208 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote215 views1 answer
How to connect to xampp sql server on windows cmd
SQL
13 votes208 views2 answers
Get date from now() mysql
SQL
5 votes212 views4 answers
Mysql on duplicate key update
SQL
0 vote228 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote197 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
1 vote202 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote250 views1 answer
Pl sql join 3 tables
SQL