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 vote305 views1 answer
DATEDIFF minute postgres
SQL
0 vote305 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
0 vote294 views1 answer
Print mysql
SQL
2 votes303 views1 answer
Datetrunc
SQL
7 votes292 views2 answers
Show size database mysql
SQL
3 votes274 views1 answer
Delete all content in table mysql
SQL
0 vote323 views1 answer
Get total and distict row diff in sql
SQL
0 vote299 views1 answer
How to insert a uniqueidentifier in sql
SQL
6 votes286 views2 answers
Database url postgres
SQL
0 vote314 views1 answer
Oracle sql developer closed connection
SQL