Oracle create table if not exists

Create table if not exists sql

CREATE TABLE IF NOT EXISTS

> CREATE TABLE IF NOT EXISTS TEAMS
> (TEAMNO      INTEGER NOT NULL PRIMARY KEY,
> EmployeeNO    INTEGER NOT NULL,
> DIVISION    CHAR(6) NOT NULL);

Oracle create table if not exists

DECLARE								-- Oracle
    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 vote292 views1 answer
Save single sql query result boolean spring boot
SQL
2 votes315 views1 answer
SQL column name Postgre
SQL
20 votes345 views1 answer
Get all table name in sql through php
SQL
3 votes296 views2 answers
Mysql add 2 hours
SQL
2 votes307 views1 answer
Oracle find unusable indexes
SQL
8 votes312 views1 answer
Show mysql user table
SQL
0 vote277 views2 answers
Spring properties file for db
SQL
0 vote325 views1 answer
Lost connection to mysql
SQL
4 votes306 views2 answers
Mysql select where starts with
SQL
1 vote317 views1 answer
Describe table in sql
SQL