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 votes105 views2 answers
Add column table pl sql
SQL
1 vote121 views1 answer
Apex select list ORA-20999
SQL
0 vote116 views1 answer
Get date ISO in psql
SQL
0 vote108 views1 answer
Can we rollback in sql
SQL
18 votes116 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote99 views1 answer
List mysql tables and views
SQL
0 vote66 views1 answer
Mysql sleep connections
SQL
0 vote105 views2 answers
Postgresql change user role grant
SQL
0 vote107 views1 answer
Mysql c commands
SQL
0 vote112 views1 answer
Min varias colunas spark sql
SQL