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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to add and populate a new column?

Re: How to add and populate a new column?

From: John Verbil <jverbil_at_netmail.mnet.uswest.com>
Date: 1996/12/20
Message-ID: <32BB0B5C.6663@netmail.mnet.uswest.com>#1/1 







Gus Spier wrote:


> 

> Could some kind of DECODE be added to a cursor to translate the rowid to

> a rank?

> 

> Gus




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
Information Technologies
jverbil_at_uswest.com
(303) 896-0916


Received on Fri Dec 20 1996 - 00:00:00 CST












Original text of this message













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