Lets see easy method to find-out root cause of any DML operation easily by following below steps:
Requirement is to track DML operation errors in one unique table.
Lets say i have below table.
CREATE TABLE TRANS(T_ID INTEGER,AMOUNT NUMBER(10,2))
alter table TRANS add constraint T_ID_PK primary key(T_ID);
insert into TRANS values (1,21);
insert into TRANS values (5,5.75);
Commit;
Click on below images to get enlarged size.
Requirement is to track DML operation errors in one unique table.
Lets say i have below table.
CREATE TABLE TRANS(T_ID INTEGER,AMOUNT NUMBER(10,2))
alter table TRANS add constraint T_ID_PK primary key(T_ID);
insert into TRANS values (1,21);
insert into TRANS values (5,5.75);
Commit;
Click on below images to get enlarged size.
 |
Update Scenario:
