By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE OR REPLACE PROCEDURE P_DUP_DEL_CREATE_TAB
IS
TABLE_DOES_NOT_EXIST EXCEPTION;
PRAGMA EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942);
BEGIN
EXECUTE IMMEDIATE 'TRUNCATE TABLE T_DUPLICATE_TABLE';
EXCEPTION
WHEN TABLE_DOES_NOT_EXIST THEN
EXECUTE IMMEDIATE 'CREATE TABLE T_DUPLICATE_TABLE (
F_NUMBER NUMBER(2),
S_NUMBER NUMBER(1),
CONSTRAINT ID PRIMARY KEY (F_NUMBER, S_NUMBER)
)';
END P_DUP_DEL_CREATE_TAB;
/
BEGIN
P_DUP_DEL_CREATE_TAB();
END;
/
1 rows affected
INSERT INTO T_DUPLICATE_TABLE (F_NUMBER, S_NUMBER) VALUES (1, 2);
1 rows affected
COMMIT;
SELECT * FROM T_DUPLICATE_TABLE;
| F_NUMBER | S_NUMBER |
|---|---|
| 1 | 2 |
BEGIN
P_DUP_DEL_CREATE_TAB();
END;
/
1 rows affected
SELECT * FROM USER_ERRORS;
SELECT * FROM T_DUPLICATE_TABLE;