Re: where is the error?

From: Pier Gaetano Novara <pier.gaetano.novara_at_gmail.com>
Date: 1 Mar 2005 01:22:09 -0800
Message-ID: <1109668929.579094.103780@o13g2000cwo.googlegroups.com>

Hi Daniel,
the version is 9.
The business problem is not clear? I have a table and I need a select that contain a row togheter with the next row (in order by rowid) so I would like to make a join between rowid and rowid+1 but I'm not sure it works: I have used the funtion DBMS_ROWID.ROWID_ROW_NUMBER here a sample
SELECT
*
FROM
tab a ,
tab b
WHERE
DBMS_ROWID.ROWID_ROW_NUMBER (a.ROWID)=DBMS_ROWID.ROWID_ROW_NUMBER (b.ROWID)+1 Received on Tue Mar 01 2005 - 03:22:09 CST