A m Z o n e

Random numbering

How to auto generate random numbers in Oracle?

Use dbms_random package

 For generating a random number (positive or negative
         dbms_random.random

 For generating a random number greater than 0 and less than 1
         dbms_random.value 

 For generating a random number between 1 to 1000, a predefined set
         dbms_random.value(1,1000) 

 For generating an upper case string of 10 characters
         dbms_random.string('U',10)

 For generating an lower case string of 10 characters
         dbms_random.string('L',10) 

 For generating an alpha numeric string of 10 characters
         dbms_random.string('A',10)

 For generating an upper case alpha numeric string of 10 characters
         dbms_random.string('X',10)

 For generating a string of printable 10 characters only
         dbms_random.string('P',10)



 Example for calling the dbms_random package
    select dbms_random.random from dual; 

         {or}
 
     declare 
       l_num number := dbms_random.random; 
     begin 
       dbms_output.put_line(to_char(l_num)); 
     end; 

Press the Back button of you Browser to go to previous page
Home