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?