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

Home -> Community -> Usenet -> c.d.o.server -> ROWNUM

ROWNUM

From: deana strbevski <deana.strbevski_at_ina.hr>
Date: Thu, 08 Feb 2001 13:24:43 +0100
Message-ID: <3A82900B.FF08294F@ina.hr>

I wonder if select

select a into :b
from tab
where cond and ROWNUM = 1;

goes twice ? 1. to get first row

                     2. to see if any rows left
Received on Thu Feb 08 2001 - 06:24:43 CST

Original text of this message

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