Home » Developer & Programmer » Forms » Urgent !!!! Random Function
Urgent !!!! Random Function [message #82776] Thu, 03 July 2003 04:01 Go to next message
Dicky
Messages: 7
Registered: October 2002
Junior Member
Can anyone tell me if Oracle Form Builder have "Random" function ??
Re: Urgent !!!! Random Function [message #82789 is a reply to message #82776] Fri, 04 July 2003 23:01 Go to previous messageGo to next message
sujit
Messages: 94
Registered: April 2002
Member
Hi, yes, you can use sample(no) in a query. hope you can use it.
select * from emp sample (10);

Sujit
Can u explain how it will work [message #82807 is a reply to message #82789] Mon, 07 July 2003 06:24 Go to previous messageGo to next message
Sun
Messages: 92
Registered: August 2002
Member
can u expln what it will do.. is sample a function ??
Re: Can u explain how it will work [message #82813 is a reply to message #82807] Mon, 07 July 2003 23:02 Go to previous messageGo to next message
sujit
Messages: 94
Registered: April 2002
Member
Hi sun,
Thanx for your reply regarding my question "go_item Fails!!". I will try it out.
Yes SAMPLE is a function SAMPLE (n number)
it takes n as a parameter and brings back n% of rows of table randomly.
Sujit
Re: Can u explain how it will work [message #82816 is a reply to message #82813] Tue, 08 July 2003 00:03 Go to previous message
Sun
Messages: 92
Registered: August 2002
Member
Thanks a lot sujit. Even i have tested it and i was in an assumption that is should be based on percentage..

thanks
sun
Previous Topic: Communicating Between Forms 3.0 and Forms 6.0 using SSH Protocol??
Next Topic: designing radio_buttons in datablock
Goto Forum:
  


Current Time: Sat Mar 02 20:47:12 CST 2024