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

Home -> Community -> Usenet -> c.d.o.misc -> rownum question

rownum question

From: <ptsao_at_sequeltech.com>
Date: 1997/01/29
Message-ID: <32EFD1DB.A7D@sequeltech.com>#1/1

Hi,

I was able to do

  select * from table where rownum = 1;
  select * from table where rownum <= 20;   update table

     set id = rownum;

but, I CAN NOT do

  select * from table where rownum = 2;
  select * from table where rownum = 3;
  ...

Can someone tell me why?

Thanks,

Phil Tsao Received on Wed Jan 29 1997 - 00:00:00 CST

Original text of this message

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