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 vote198 views1 answer
Postgresql alter table sequence
SQL
6 votes159 views2 answers
Oracle undotbs usage
SQL
0 vote159 views1 answer
Mysql db dump restore max file size issue
SQL
14 votes156 views2 answers
Oracle limit rows
SQL
0 vote161 views2 answers
Identity column in sql server
SQL
-1 vote171 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
1 vote158 views1 answer
Mamp mysql path mac
SQL
1 vote154 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote157 views3 answers
Remove folders from remote git
SQL
2 votes113 views1 answer
Sql group by different columns
SQL