/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 vote96 views1 answer
Sql server manager close connection
SQL
1 vote113 views1 answer
Sql first day quarter
SQL
0 vote50 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
2 votes104 views2 answers
Insert all in sql
SQL
0 vote98 views1 answer
Array aggre distinct postgres
SQL
0 vote160 views1 answer
Postgresql powershell query
SQL
0 vote111 views2 answers
How covert into int in maria db
SQL
25 votes102 views6 answers
Sql update query
SQL
1 vote97 views1 answer
Oracle avg
SQL
5 votes126 views3 answers
Show indexes mysql
SQL