search for: no_of_row

..., the distributions of the v1 and v2 should not be other than normal or slightly positively skewed or slightly negatively skewed. In Oracle, random data is generated with packaged function dbms_random.value(lowerbound, upperbound), which can be called from SQL query with where clause (level <= no_of_rows) for the number of rows you want. After the rows are generated, we can write custom functions to spread the data points along the y-axis, so that they wouldn't overlap. I hope this may clear the use case further. Many Thanks and Kind Regards -- Muhammad Bilal Research Assistant and Doc...

...ributions of the v1 and v2 should not be other than normal or slightly positively skewed or slightly negatively skewed. > > In Oracle, random data is generated with packaged function dbms_random.value(lowerbound, upperbound), which can be called from SQL query with where clause (level <= no_of_rows) for the number of rows you want. > > After the rows are generated, we can write custom functions to spread the data points along the y-axis, so that they wouldn't overlap. > > I hope this may clear the use case further. Not really... You can do lots of stuff with random numbe...

Please specify your goal in the oracle/psql analytical functions you know or specify what you mean by nonlinear correlation Sent from my iPhone > On Apr 9, 2016, at 6:09 AM, Muhammad Bilal <Muhammad2.Bilal at live.uwe.ac.uk> wrote: > > No its not. I am doing all these experiments for my own learning purpose. I am Oracle SQL & PLSQL programmer and I can do these things with