/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

2 votes224 views1 answer
Oracle run_duration to number
SQL
1 vote136 views1 answer
Update mysql centos
SQL
0 vote155 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
33 votes137 views2 answers
Postgres how to add field created at
SQL
2 votes182 views1 answer
Sql server: select column values as comma separated string
SQL
2 votes140 views1 answer
Oracle kill job by sid
SQL
0 vote157 views1 answer
Add SuperUser MySQL
SQL
0 vote137 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote145 views1 answer
Double in sql server example
SQL
0 vote188 views1 answer
Offset in postgresql example
SQL