Re: How can I select several result

dewbow_at_my-deja.com wrote:
>
> It's kown that we can use limit in MySQL so it's easy for us to show
> several information from select result. We can use this: select items
> from table where condition limit <start>,<records> in MySQL. How to
> realize this function in ORACLE.

You can use the ROWNUM pseudocolumn, but unfortunately you can only select WHERE ROWNUM < ??? (or <=).

-- 
Uwe Schneider - WEB.DE AG - Amalienbadstr. 41 - 76227 Karlsruhe 
Forschung & Entwicklung - Tel. (+49) 721 94329 832
"In a world without walls and fences, who needs windows and gates?"