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 vote204 views1 answer
Sql order by number not ordered
SQL
1 vote191 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
3 votes169 views2 answers
Oracle grants
SQL
1 vote164 views1 answer
Oracle truncate partition
SQL
3 votes185 views2 answers
Postgresql select all column names
SQL
0 vote170 views2 answers
How to combine diff colmun value using group by postgres
SQL
3 votes248 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
1 vote173 views1 answer
What is a Database?
SQL
0 vote156 views1 answer
Create bakupd database sqlserver
SQL
1 vote179 views1 answer
Mysql last year
SQL