Re: select and update by row number

Steve Crowe wrote:
> 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.

  select * from table_name where rownum=1 or rownum=6205 or rownum=12410;

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841