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 votes195 views4 answers
Truncate syntax in sql
SQL
6 votes185 views2 answers
Postgresql restore from dump
SQL
0 vote174 views1 answer
Oracle search columns in schema
SQL
-1 vote264 views3 answers
PS5
SQL
4 votes193 views3 answers
Sql drop primary key
SQL
2 votes130 views1 answer
Sql view column data type
SQL
17 votes207 views3 answers
Postgresql list users
SQL
0 vote175 views2 answers
Drop check constraint in ms sql
SQL
0 vote175 views1 answer
Distinct data types in a table sql query
SQL
0 vote172 views1 answer
Prepared statement mysql java delete selected rows
SQL