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 vote196 views1 answer
Lister les index d'une table oracle
SQL
0 vote271 views1 answer
Delete from IN subquery
SQL
0 vote217 views1 answer
Mysql count by month
SQL
1 vote239 views3 answers
Mysql on delete set null
SQL
4 votes222 views1 answer
Conda install sqlalchemy
SQL
0 vote208 views1 answer
Oracle search in date columns
SQL
23 votes236 views4 answers
Uninstall postgresql ubuntu
SQL
1 vote227 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote233 views1 answer
Firebase sql
SQL
18 votes219 views4 answers
Mysql current date between two dates
SQL