/SQL/Create table if not exist with exceptions

Create table if not exist with exceptions

declare
v_sql LONG;
begin

v_sql:='create table EMPLOYEE
  (
  ID NUMBER(3),
  NAME VARCHAR2(30) NOT NULL
  )';
execute immediate v_sql;

EXCEPTION
    WHEN OTHERS THEN
      IF SQLCODE = -955 THEN
        NULL; -- suppresses ORA-00955 exception
      ELSE
         RAISE;
      END IF;
END; 
/

Source: stackoverflow.com

Similar codes

0 vote329 views1 answer
How to output a different column name in mysql
SQL
1 vote342 views1 answer
Mysql how to truncate table with foreign keys
SQL
1 vote347 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
5 votes390 views1 answer
Oracle drop index if exists
SQL
0 vote305 views1 answer
Mysql with
SQL
3 votes299 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
11 votes361 views1 answer
Ddl view
SQL
3 votes322 views2 answers
Sql random integer
SQL
0 vote316 views1 answer
Sql if else in select
SQL
5 votes339 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL