/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

1 vote172 views1 answer
User privileges postgresql information_schema
SQL
5 votes203 views4 answers
SQL Order of execution
SQL
2 votes183 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote181 views1 answer
Asp.net core sql server stored procedure
SQL
1 vote176 views1 answer
Postgres check blocking
SQL
0 vote185 views1 answer
Mysql db dump restore max file size issue
SQL
1 vote200 views2 answers
Postgresql truncate cascade restart identity
SQL
1 vote197 views1 answer
Sample in sql
SQL
0 vote234 views1 answer
Alternative for LIMIT sql
SQL
1 vote175 views1 answer
Restart identity postgresql
SQL