troubleshooting Question

using custom distribution in Oracle / PL/SQL

Avatar of choochim
choochim asked on
Oracle Database
4 Comments1 Solution592 ViewsLast Modified:
Looking for some urgent help with implementing a custom statistical distribution in Oracle 10g: The scenario goes like this: I want a function that returns a single value based on a table that looks like this:
Value   Freq%
*******  *********
A         5.3%
B         4.8 %
C         5.1 %
D         10.5 %
etc..etc..

When I call this function, I want it to return the value of A 5.3% of the time, the value of B 4.8% of the time and so on and so forth.

Is this possible using PL/SQL? if so could someone shed some light on how to approach this problem.

Much appreciated.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros