/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 vote195 views1 answer
Mysql date time string format python
SQL
1 vote181 views1 answer
PLS-00225 type
SQL
0 vote287 views1 answer
Mysql get nested records
SQL
1 vote200 views1 answer
SQL: merging multiple row data in string
SQL
0 vote214 views1 answer
Make parameters nullable in sql server
SQL
0 vote203 views1 answer
Mysql Like(searching in the string)
SQL
3 votes187 views2 answers
Sql paging query
SQL
5 votes234 views2 answers
Functions
SQL
10 votes212 views6 answers
Between sql
SQL
0 vote201 views1 answer
How to query without duplicate rows in sql
SQL