PROCEDURE solve (my_problem IN varchar2) IS
my_idea := have_great_idea (my_problem) ;
my_code := start_coding (my_idea) ;
IF i_hit_complications (my_idea)
new_problem := the_complications (my_idea);
NULL; --we will never get here
This abuse of recursion was inspired by @ThePracticalDev !
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”.