OraFAQ Forum: Forms » To generate random number

Home » Developer & Programmer » Forms » To generate random number

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To generate random number [message #198550]

Tue, 17 October 2006 10:16

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.

Report message to a moderator

Re: To generate random number [message #198555 is a reply to message #198550]

Tue, 17 October 2006 11:17

sukhadukkham
Messages: 3
Registered: September 2006
Location: Switzerland

Junior Member

you may use dbms_random to do this
regards
daniel

Report message to a moderator

Re: To generate random number [message #199749 is a reply to message #198550]

Thu, 26 October 2006 02:06

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:33:06 CDT 2024