Re: How to add and populate a new column?

From: Roger Snowden <rsnowden_at_labinterlink.com>
Date: 1997/01/03
Message-ID: <01bbf991$d4ae7dc0$096fc589@roger.labinterlink.com>#1/1

John Verbil <jverbil_at_netmail.mnet.uswest.com> wrote in article <32BB0B5C.6663_at_netmail.mnet.uswest.com>...
> I don't see how. ROWIDs have no correlation to any ORDER BY clause in a
> cursor. ROWNUM will assign numbers 1-N to each row returned based on
> the ORDER BY clause.
> John Verbil
> U S WEST Communications

Sorry, but this is dangerously incorrect. ROWNUM is a psuedocolumn which identifies relative row number within a result set, and is assigned BEFORE the order by clause is executed.

Roger Received on Fri Jan 03 1997 - 00:00:00 CST