Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> R: Limit rowcount

R: Limit rowcount

From: Andrea LUCIANO <andrea.luciano_at_icteam.it>
Date: 2000/06/14
Message-ID: <dik7i8.938.ln@turner.icteam.it>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US