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 votes159 views1 answer
Where id is in list sql
SQL
0 vote157 views2 answers
Select last 30 days sql
SQL
0 vote201 views1 answer
Tsql find procedure with name
SQL
0 vote120 views2 answers
Postgresql display subquery as json
SQL
4 votes273 views1 answer
Oracle table statistics
SQL
9 votes138 views4 answers
Add primary key to existing table sql
SQL
13 votes156 views5 answers
Sql default
SQL
0 vote152 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote142 views1 answer
Postpresql relation not found
SQL
0 vote144 views1 answer
Import mysql'
SQL