Create table if not exist

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);

Create table if not exist

declare
nCount NUMBER;
v_sql LONG;

begin
SELECT count(*) into nCount FROM dba_tables where table_name = 'EMPLOYEE';
IF(nCount <= 0)
THEN
v_sql:='
create table EMPLOYEE
(
ID NUMBER(3),
NAME VARCHAR2(30) NOT NULL
)';
execute immediate v_sql;

END IF;
end;

Source: stackoverflow.com

Similar codes

0 vote155 views1 answer
Joins vs includes
SQL
4 votes141 views2 answers
Truncate oracle
SQL
0 vote175 views1 answer
Flask sqlalchemy session delete
SQL
4 votes96 views1 answer
Generate class from sql table c#
SQL
0 vote179 views1 answer
Postgresql concat string with separator
SQL
0 vote172 views1 answer
Mysqldump: error:
SQL
0 vote146 views1 answer
MySQL error code 2068
SQL
1 vote134 views1 answer
Oracle lock user
SQL
0 vote177 views2 answers
Getting customers with no orders sql
SQL
1 vote158 views2 answers
Restart identity cascade
SQL