Re: sql query find rows included in a list: 2nd row , 8th..

in oracle you cm insert in where clauses the statement (for example)

" rownum = 10"
nd the result set will show only number ten row.

but if the table contin a lot of data the access is not rapid!!!

Hi

ChristineL_at_Visionyze.com ha scritto nel messaggio ...
>Hi,
>
>I want to select in a big table the rows where the rank specified in a
>ArrayList.
>For example: ArrayList list = {1, 5, 100, 104, 10000}. (1 means the
>first row, 5 means the 5th rows,...).
>The database can be very big and I need a rapid access.
>
>Example: List = {1, 3}
>table
>a aaa <--
>b bbb
>c ccc <--
>...
>the result is: a aaa
> c ccc
>
>At this moment, I read the rows 1 by 1 in a loop with an index and when
>the index is included in my ArrayList, I keep this row. The problem with
>this solution: Too slow with a big table.
>
>Do you have a solution for me?
>
>Thank you
>Christine
>
>
>--
>Posted via CNET Help.com
>http://www.help.com/
Received on Sun Apr 22 2001 - 04:27:42 CDT