Pier Gaetano Novara wrote:
> 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
>
The business case would describe why you would need rowid
and rowid+1.
Business wise, rowid's say nothing, absolutely nothing.
What's more - the outcome of your query is not repeatable,
that is, tomorrow, you may have different values from table B
with the same values for table A.
--
Regards,
Frank van Bortel
Received on Tue Mar 01 2005 - 05:47:08 CST
