• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sequence number generation

 
scott prichard
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am working on a stored procedure which selects certain records. But I have a situation where I have to append a 2 digit sequnce number for every record.
I dont think its going to be a problem if it repeats after 99, but I have to generate a 2 digit sequence number. I tried using dbms_random but it generates only one random number per call. So same number is appended all the time. Any ideas?

Scott.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic