/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

49 votes312 views6 answers
Get duplicate records in sql
SQL
0 vote269 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote240 views1 answer
What are the aggregate function in sql
SQL
1 vote254 views1 answer
Delete row mssql
SQL
0 vote279 views2 answers
Postgresql gset
SQL
0 vote258 views1 answer
How to find unique key in sql
SQL
24 votes251 views5 answers
Sql reset auto increment
SQL
16 votes283 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
6 votes272 views3 answers
Commit in sql
SQL
0 vote247 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL