Ok, I have to write an Oracle trigger in which I need to do a Select on the table a new record is being added to. I need to get the max value of a column and compare it with the value for that column for the new record.
But running it gives a table mutating error, which makes sense because you are trying to get a value from the table that is being modified at that point. Of course I could move the logic out to the Java class, but in what other way can it be done in the database?
The future is here. It's just not evenly distributed yet. - William Gibson
Consultant @ Xebia. Sonny GillTweets