This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using Sequence to populate ID(SOLVED)

 
Matt Kohanek
Village Idiot
Ranch Hand
Posts: 484
Java jQuery Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Jan Cumps
Bartender
Posts: 2584
11
C++ Linux Netbeans IDE
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you have to use nextval to retrieve the unique sequence value.

After that, curval will return the value created by that nextval call.

curval only works after you have called nextval.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic