/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 vote362 views1 answer
Alter check command
SQL
0 vote363 views1 answer
Sql alter table add column if exists
SQL
0 vote294 views1 answer
Finish transaction sql
SQL
15 votes403 views3 answers
Mysql update add to existing value
SQL
0 vote333 views1 answer
Nueva tabla mysql
SQL
8 votes347 views1 answer
Oracle add months to sysdate
SQL
0 vote368 views2 answers
Sql day from datetime
SQL
0 vote338 views1 answer
Laravel eloquent get generated sql
SQL
0 vote367 views1 answer
Oracle job session
SQL
13 votes289 views2 answers
Oracle all source
SQL