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 vote198 views1 answer
Psotgres multiple values
SQL
0 vote214 views1 answer
Make parameters nullable in sql server
SQL
2 votes243 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote186 views1 answer
How to Remove milliseconds from Date time
SQL
-1 vote193 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
-2 votes201 views1 answer
Remove root password mysql
SQL
0 vote192 views1 answer
Output table plsql
SQL
0 vote226 views1 answer
Sql select lowest value row
SQL
0 vote218 views1 answer
T-SQL - Where Used List (Table/View)
SQL
14 votes231 views6 answers
Finding duplicate rows mysql
SQL