/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

2 votes181 views2 answers
Select multiple tables mysql
SQL
0 vote188 views1 answer
Mysql command prompt date insert format
SQL
7 votes207 views6 answers
Mysql group concat
SQL
4 votes199 views1 answer
Sql quote in string
SQL
0 vote181 views1 answer
Ffeathers express mysql application users login
SQL
0 vote243 views1 answer
Mysql remove last character
SQL
0 vote194 views1 answer
MySQL error code 2068
SQL
0 vote193 views1 answer
Mysql set boolean default value
SQL
1 vote239 views1 answer
Select last row from SQL Table
SQL
13 votes177 views2 answers
Mysql order by multiple columns
SQL