Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: where is the error?

Re: where is the error?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 25 Feb 2005 08:54:19 -0800
Message-ID: <1109350281.71678@yasure>


Pier Gaetano Novara wrote:

> Ok is clear, but if I would like to do an icrement of the rowid to
> point the next row how could I do?
> I need to make a jouin using the same table 2 times:
> select
> ...
> from
> table a, table b
> where
> a.rowid=b.rowid+1

You need to understand what a ROWID is. There is no such concept in a heap table as "next row."

What is the business problem you are trying to solve.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Feb 25 2005 - 10:54:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US