/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 votes213 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote218 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote223 views1 answer
Mysql get date diff in months
SQL
0 vote219 views1 answer
Mysql order by where condition sub query
SQL
13 votes212 views2 answers
Check if value is null mysql
SQL
7 votes235 views1 answer
Buy forge mods server hosting
SQL
0 vote252 views1 answer
Get substract count sql
SQL
1 vote211 views1 answer
Xampp import sql file command line
SQL
0 vote276 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote225 views4 answers
How to connect form to database
SQL