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:
B 4.8 %
C 5.1 %
D 10.5 %
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.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.