Re: where is the error?

Pier Gaetano Novara wrote:

> The problem is: in a table I have a date field and a integer field, I
> need to select all the rows where the integer field is <=x and
> determine the row count distance between these rows.
> For tof: what you mean with RDBMS_ROWID?
> Thanks and regards

What you are asking for is not possible in a heap table. There is no concept of "row count distance between these rows." The question is meaningless.

Once again ... what is the business problem and what version of Oracle?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)