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 vote190 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote200 views1 answer
QCompleter con sql
SQL
1 vote204 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
2 votes204 views1 answer
Oracle sql merge
SQL
1 vote200 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote193 views1 answer
Oracle table free space
SQL
5 votes208 views3 answers
Mysql remove unique constraint
SQL
0 vote208 views1 answer
Mysql convert charset
SQL
0 vote204 views1 answer
Update database collation in postgresql
SQL
0 vote204 views1 answer
Create table sql generator
SQL