Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> R: Limit rowcount
You have to use 'rownum' in your query or just fetch the first row (the implementation of that depend on the language you are using, in PL/SQL declare a cursor and try to fetch the first row). So in Oracle's SQL you can type:
select * from table where rownum<2;
Paolo Polce <java.group_at_bricabrac.it> wrote in message
8h83sf$61bm$1_at_stargate1.inet.it...
> Hello,
>
> I want to know if I can get results from a query like "select * from
ecc.
> ecc.". I don't need all the result rows... I only want to know If there
are
> rows or not.
>
> The full select is slow, considering that It's useless for me ;-)
> Is there a fater way?
>
>
> Thank you.,
>
> Paolo Polce
> Naples/Italy
>
>
>
Received on Wed Jun 14 2000 - 00:00:00 CDT