/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

3 votes153 views1 answer
Create a table with an id in mysql
SQL
0 vote148 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
2 votes162 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote155 views1 answer
Generate sequence number in sql server
SQL
0 vote163 views1 answer
Oracle sql add column auto generated value
SQL
0 vote150 views1 answer
Mysql begin statement
SQL
-1 vote151 views1 answer
Round up and down sql
SQL
0 vote139 views1 answer
Dump multiple tables mysql
SQL
0 vote152 views1 answer
Trigger value from maltiple table to single table mysql
SQL
12 votes144 views2 answers
Delete all nodes neo4j
SQL