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

5 votes367 views1 answer
Oracle get ddl
SQL
0 vote336 views1 answer
Replace divide by zero error with 0 in sql
SQL
2 votes302 views1 answer
Sql ignore accents
SQL
0 vote317 views1 answer
Mysql drop vs delete
SQL
1 vote309 views1 answer
Mysql f# examples
SQL
0 vote304 views1 answer
SQL Error 1040 : Too many connections
SQL
1 vote373 views1 answer
Sql select row with max date
SQL
0 vote313 views1 answer
Get only structure database mysql
SQL
0 vote333 views1 answer
T sql dynamic top n query
SQL
0 vote318 views1 answer
Create database store
SQL