/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 vote182 views1 answer
Check index sql server
SQL
0 vote194 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote197 views1 answer
Import sql in postgresql
SQL
8 votes196 views2 answers
Mysql grant all privileges to user from any host
SQL
1 vote236 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote200 views1 answer
Nosql vs sql
SQL
1 vote212 views1 answer
Minus vs intersect in sql
SQL
0 vote246 views4 answers
Best data type to represent money in mysql
SQL
3 votes198 views1 answer
Sql double index
SQL
2 votes199 views1 answer
Query any digits record
SQL