/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

1 vote64 views1 answer
Psql kill pid
SQL
0 vote107 views1 answer
List column names of multiple tables psql
SQL
0 vote112 views1 answer
What is SQL data store?
SQL
1 vote113 views1 answer
Ef core 5.0 usesqlserver not found
SQL
0 vote111 views1 answer
Sql query wordpress export post
SQL
5 votes116 views1 answer
Oracle asynchronous update
SQL
0 vote120 views1 answer
Postgre query date
SQL
17 votes107 views6 answers
Current date in sql
SQL
0 vote102 views1 answer
Using GROUP BY in MySQL Join Table
SQL
-1 vote64 views1 answer
Oracle db list usernames
SQL