Re: Select ROWID with a criteria
From: (wrong string) ås <odd.morten.sveas_at_accenture.com>
Date: 1 May 2003 04:02:05 -0700
Message-ID: <4306a83.0305010210.7ec4e23_at_posting.google.com>
Date: 1 May 2003 04:02:05 -0700
Message-ID: <4306a83.0305010210.7ec4e23_at_posting.google.com>
> > You can NOT "select a range of rows using rowid number.
Sure you can.
SELECT EMP_NAME
FROM EMP
WHERE rowid between chartorowid(10) and chartorowid(1000)
However you wount get any row here. The rowid can be represented as a 9(or something) char long string, ant it increases for every insert. You can get the char reprenentation of the rowid by useing the rowidtochar(rowid) function.
Regards
Odd M
Received on Thu May 01 2003 - 13:02:05 CEST