Home » Developer & Programmer » Forms » To generate random number
icon5.gif  To generate random number [message #198550] Tue, 17 October 2006 10:16 Go to next message
miferdin
Messages: 1
Registered: October 2006
Location: India
Junior Member
Hi,
Would you please help me in generating random numbers through 9i forms developer from a set of numbers in a database.
Re: To generate random number [message #198555 is a reply to message #198550] Tue, 17 October 2006 11:17 Go to previous messageGo to next message
sukhadukkham
Messages: 3
Registered: September 2006
Location: Switzerland
Junior Member
you may use dbms_random to do this
regards
daniel
Re: To generate random number [message #199749 is a reply to message #198550] Thu, 26 October 2006 02:06 Go to previous message
lunate
Messages: 74
Registered: October 2006
Location: Pakistan
Member

hi buddy ,
u can do just like that in order to generate random numbers one by one.

SQL> SELECT * FROM
2 ( SELECT empno FROM EMP
3 ORDER BY dbms_random.VALUE )
4 WHERE ROWNUM < 11;

EMPNO
----------
7934
10
7499
7788
1100
7369
7900
7782
7698
7876

10 rows selected.

Previous Topic: Forms Window problem
Next Topic: How to use GET_FILE_NAME in 9i
Goto Forum:
  


Current Time: Tue Dec 06 10:30:27 CST 2016

Total time taken to generate the page: 0.08980 seconds