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

1 vote191 views1 answer
Psql client write to bash variable
SQL
1 vote147 views1 answer
Psql connections
SQL
0 vote173 views1 answer
How to combine rows in sql server procedure
SQL
0 vote145 views1 answer
How to use sqlcommand
SQL
1 vote161 views1 answer
Postgresql create table with timestamp
SQL
1 vote148 views10 answers
Stack overflow
SQL
6 votes150 views2 answers
Mysql first day of month
SQL
2 votes146 views1 answer
How to select first row of database sql
SQL
1 vote136 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
8 votes148 views3 answers
Postgres connection string
SQL