Home -> Usenet -> comp.databases.oracle -> select and update by row number

select and update by row number

From: Steve Crowe <logicprobe_at_bbs.kis.net>
Date: 1996/11/30
Message-ID: <57oh2l$2a4_at_news.kis.net>#1/1 







Hello,



I am taking a CMIS course on databases. I am tring to update and query
my database by row number. I have a table with 12,410 records in it. I
need to query the 1st,  the 6,205th, and the 12,410th rows. I tried
using RowNum in a where clause, but no dice. I also am thinking about
using RowID, but I am not sure how to go about this.



Thanks for any help,


Steve Crowe


logicprobe_at_bbs.kis.net
Received on Sat Nov 30 1996 - 00:00:00 CET












Original text of this message