I wrote a quiz for the PL/SQL challenge on sequence pseudocolumns, and I noticed that a couple of the answers tricked a lot of people who took the quiz. Time for a blog post on what you can’t do with NEXTVAL!
If you want to try the quiz, do it now before reading on:
Pseudocolumns: Sequence Pseudocolumns from “Weekly SQL Quiz: 31 January – 6 February 2015”.
Read more