OraFAQ Forum: Forms » Urgent !!!! Random Function

Home » Developer & Programmer » Forms » Urgent !!!! Random Function

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

Urgent !!!! Random Function [message #82776]

Thu, 03 July 2003 04:01

Dicky
Messages: 7
Registered: October 2002

Junior Member

Can anyone tell me if Oracle Form Builder have "Random" function ??

Report message to a moderator

Re: Urgent !!!! Random Function [message #82789 is a reply to message #82776]

Fri, 04 July 2003 23:01

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

Report message to a moderator

Can u explain how it will work [message #82807 is a reply to message #82789]

Mon, 07 July 2003 06:24

Sun
Messages: 92
Registered: August 2002

Member

can u expln what it will do.. is sample a function ??

Report message to a moderator

Re: Can u explain how it will work [message #82813 is a reply to message #82807]

Mon, 07 July 2003 23:02

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

Report message to a moderator

Re: Can u explain how it will work [message #82816 is a reply to message #82813]

Tue, 08 July 2003 00:03

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 21:28:07 CDT 2024