/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 vote186 views1 answer
Sql count more than 1
SQL
0 vote187 views1 answer
How to find sql server installation folder
SQL
0 vote177 views1 answer
Json not contains mysql
SQL
0 vote180 views2 answers
How to start postgresql laravel
SQL
1 vote174 views1 answer
Select from one table where not on the other
SQL
13 votes169 views5 answers
Oracle list tables
SQL
3 votes184 views2 answers
Enter mysql command line
SQL
3 votes186 views1 answer
Postgresql today - 1 year
SQL
0 vote226 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote165 views8 answers
Convert sql query to linq online
SQL