Hi,
I've wrote a statement which generates 150.000 rec's, randomized it and now
I would like to export 1st 10.000 rows (take the sample of data) but don't
know how (?)
I would appreciate any help
BR
KrunoG
On Mon, 18 Sep 2006 10:30:46 +0200, "KrunoG"
wrote:
>I've wrote a statement which generates 150.000 rec's, randomized it and now
>I would like to export 1st 10.000 rows (take the sample of data) but don't
>know how (?)
>I would appreciate any help
You mentioned "1st" which implies ordering, so order in a subquery, and use
"rownum <= 10000" in the outer query to get only that many rows.
Or you've also mentioned sampling; Oracle has a "sample" clause that you can
use to get a percentage of the data:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b 14200/statements_10002.htm#i2065953
--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
"Andy Hassall"
news:gb2ug29t6cqqg4c5kb2qhbmnjcjtrv58i7@4ax.com...
> You mentioned "1st" which implies ordering, so order in a subquery, and
use
> "rownum <= 10000" in the outer query to get only that many rows.
>
> Or you've also mentioned sampling; Oracle has a "sample" clause that you
can
> use to get a percentage of the data:
>
>
>
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b 14200/statements_10002.htm#i2065953
>
> --
> Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
> http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
I've tried this but It's not working
ORDER BY dbms_random.valuerownum <= 10000
Sorry, I've hit enter before ending post :|
ORDER BY dbms_random.value
rownum <= 10000
I have problem with sampling because of multiple table joins. I realize that
every query is individual, perhaps a whole code could give a clue (?)