/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 vote174 views1 answer
Pgadmin save data greyed out
SQL
2 votes166 views2 answers
Mysql add hours to time field
SQL
0 vote154 views1 answer
Mysql local password denied
SQL
0 vote157 views1 answer
Stratified sampling sql
SQL
0 vote101 views1 answer
Mysql convert column to uppercase
SQL
0 vote263 views1 answer
How to use select union and loop
SQL
0 vote146 views1 answer
Split string by comma in sql server
SQL
3 votes146 views2 answers
Sql asc
SQL
10 votes149 views1 answer
Oracle object dependencies
SQL
0 vote148 views1 answer
Sql roll up rows into columns
SQL