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 vote275 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote286 views1 answer
T-sql email validation
SQL
2 votes260 views1 answer
Oracle find unusable indexes
SQL
1 vote275 views3 answers
Connect to mysql c# connection string C#
SQL
1 vote303 views1 answer
Oracle plan hash value
SQL
-1 vote345 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
0 vote278 views1 answer
Sql query to force the database to be drop
SQL
0 vote257 views1 answer
Mysql date time string format python
SQL
14 votes269 views3 answers
Sql trim from string
SQL
6 votes254 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL