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

2 votes275 views2 answers
Get all columns from table sql
SQL
0 vote218 views1 answer
How to get last client id sql
SQL
0 vote274 views1 answer
Mysql two joins
SQL
1 vote273 views1 answer
Sql server update column based on another table
SQL
0 vote274 views1 answer
C# check if mysql query modified rows
SQL
1 vote283 views3 answers
Nth highest salary
SQL
1 vote296 views1 answer
Epoch time converter in snowflake
SQL
25 votes312 views4 answers
Import mysql dump command line
SQL
0 vote287 views1 answer
Check connections to database postgres
SQL
0 vote354 views1 answer
TSQL Find csv file in folder
SQL