/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 vote255 views1 answer
Shows all databases created by user in ms sql
SQL
6 votes237 views2 answers
Sql query to get the number of rows in a table
SQL
1 vote257 views2 answers
Oracle leftmost characters
SQL
0 vote242 views4 answers
How to connect form to database
SQL
0 vote255 views1 answer
Show tables in cassandra cql
SQL
19 votes219 views6 answers
Laravel sql query
SQL
0 vote274 views1 answer
Create table using the clause with as
SQL
1 vote230 views1 answer
Set statistics on in ssms
SQL
-1 vote232 views1 answer
Window functions in sql
SQL
6 votes257 views3 answers
Create database mysql utf8
SQL