/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 vote170 views2 answers
Sql query inner join 3 tables
SQL
3 votes185 views1 answer
Oracle list invalid password logon denied
SQL
0 vote181 views1 answer
Mysql check datetime equals date
SQL
2 votes276 views1 answer
Sql ends with string
SQL
1 vote191 views1 answer
Select inside insert query
SQL
0 vote174 views1 answer
Where name ends in SQL
SQL
0 vote170 views1 answer
Alter table engine mysql
SQL
6 votes123 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote161 views1 answer
Call function sql oracle
SQL
0 vote249 views1 answer
Do you know sql
SQL