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 vote239 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
1 vote238 views3 answers
How to filter repeated same result using sql query
SQL
1 vote244 views1 answer
Where date = max(date) in sql
SQL
0 vote227 views1 answer
C# add a textbox in mysql select
SQL
8 votes234 views1 answer
Oracle tablespace datafile max size
SQL
14 votes248 views1 answer
Oracle alter table add column not null
SQL
12 votes225 views4 answers
Mysql version query
SQL
-1 vote239 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote219 views1 answer
C# datetime to sql server datetime
SQL
3 votes231 views1 answer
Pl sql escape &
SQL