/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 vote206 views1 answer
Dual in db2
SQL
1 vote144 views1 answer
Enable mysql slow query log
SQL
1 vote172 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote219 views2 answers
Mysql where in maintain order group_concat
SQL
1 vote182 views3 answers
Union SQL
SQL
0 vote142 views1 answer
Check sql query executed wp
SQL
3 votes196 views1 answer
Select sequence oracle
SQL
0 vote208 views1 answer
Where field is null sql knex
SQL
0 vote243 views9 answers
Linq to sql converter online
SQL
0 vote222 views1 answer
Mysql last friday of current month
SQL