• Post Reply Bookmark Topic Watch Topic
  • New Topic

sequence number generation

scott prichard
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?

my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!