HI All,
I am using oracle apex 5.1. i have created interactive gird and created a manual process to save. its working as expected. I need to validate a column empno where user should not able to enter duplicate value
in the above screenshot 'EMPNO' we have 101, 102, 103. If user try to enter 101 again and press save button it should validate and show error message.
The above is just an example i can use trigger to get unique number but we are not doing it because of some business rules.
Can any one suggest me how to validate and restrict duplicate value.
Thanks in advance
Ravi