Recent content by rajk123

Thanks for your comments. I would have used constraints but it is only on some business secnarios that I want to check for the uniqueness so putting a constriant will not work. I have to do this in a pl/sql block which can be done through triggers. I am still looking for a solution using...

I would like to know how the following can be done through a trigger - When session A inserts a row in a table I would like to check for uniqueness for one of the columns through the insert trigger before commiting the row. This works well for all rows which have already been commited but...