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 vote395 views2 answers
How to get max from each department in sql
SQL
0 vote384 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
1 vote369 views1 answer
Jooq convert using gbk
SQL
0 vote351 views1 answer
Mysql add to value
SQL
0 vote369 views1 answer
Select multiple row from primary key sql
SQL
1 vote380 views1 answer
Select 2 rows in sql
SQL
4 votes405 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote375 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote358 views1 answer
Query to insert image
SQL
0 vote384 views1 answer
Sql query to find percentage of null values in a table
SQL