/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 vote153 views1 answer
Template MySQL Zabbix agent
SQL
1 vote187 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
0 vote199 views1 answer
Sql int vs integer
SQL
2 votes154 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote137 views1 answer
Oracle select invalid views
SQL
1 vote153 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote163 views1 answer
Sql describe
SQL
3 votes136 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote130 views1 answer
How to change null display in psql
SQL
1 vote161 views1 answer
Mysql search like order by best match
SQL