/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 vote207 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
5 votes208 views1 answer
Add column table sql default value
SQL
0 vote275 views1 answer
Postgressql uuid
SQL
33 votes182 views2 answers
Postgres how to add field created at
SQL
0 vote195 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote237 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote187 views1 answer
Oracle free up space in tablespace
SQL
0 vote195 views1 answer
How much table store postgres
SQL
1 vote202 views2 answers
T-sql random number for each row
SQL
0 vote246 views2 answers
How to install psql in ubuntu
SQL