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

20 votes316 views2 answers
Mysql bigint max value
SQL
2 votes407 views1 answer
Ssh mysql port forwarding
SQL
13 votes304 views3 answers
Uninstall mysql centos 7
SQL
4 votes307 views1 answer
Wilayah indonesia database
SQL
0 vote353 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
5 votes326 views1 answer
Find table from column name in sql
SQL
0 vote313 views1 answer
Mysql show foreign keys column
SQL
-2 votes323 views3 answers
Sqlite reset autoincrement
SQL
0 vote370 views1 answer
Create a view in sqlite
SQL
0 vote347 views1 answer
Kill mysqld_safe process mariadb
SQL