Hi,
Please help to solve the following scenario .
With the below table i have to find the duplication in ID1 column, With that i have to stop/ rempove the upcoming insert statements with if the ID1 data gets duplicated.
| ID | ID1 |
| 15 | AS20000 |
| 1 | Common Operation |
| 2 | Common Operation |
| 9 | Common Operation |
| 10 | Common Operation |
| 14 | AS20000 |
Either procedure or trigger required to solve the duplication entry while insertion. Duplication check against the varchar2 datatype of ID1.