I have never used sequences in pl sql before, so I am just wondering if it is best practice to use seq.nextval or seq.currval?
I do not know if using .currval will use the current number, and then the next time it is used ti will use the next number in line, or if .currval will keep using the same number over and over again.
Thanks for any advice
edit - I know I can easily answer this question by
testing it out, but I am also looking for any best practice tips for using sequences since I have never used one.