/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

6 votes435 views2 answers
Oracle compile trigger
SQL
4 votes366 views3 answers
Check if two date ranges overlap sql server
SQL
4 votes344 views1 answer
Adding data to table in sql python
SQL
2 votes407 views2 answers
Set value to null sql
SQL
1 vote437 views1 answer
Mysql get max value and id
SQL
1 vote387 views1 answer
Sql row having max
SQL
0 vote391 views1 answer
Sql query wordpress export post
SQL
0 vote353 views1 answer
Select even number id data from table
SQL
9 votes378 views3 answers
Pyodbc connect to sql server
SQL
4 votes406 views3 answers
Postgres drop all tables
SQL