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: Difference between ROWNUM & ROWID

Re: Difference between ROWNUM & ROWID

From: flux <flux_at_berlin.snafu.de>
Date: 1997/09/17
Message-ID: <341FB1DA.3C97261E@berlin.snafu.de>#1/1 







SKMGMT wrote:


> 

> CAN someone kindly tell me the difference between the two.

> 

> Also what is Concatenating indexes.




First ROWNUM is the number of rows currently fetched in a select.
Second ROWID is an internal identifier for each row in a table.
You can use ROWID for fast acces of a row.




Daniel
Received on Wed Sep 17 1997 - 00:00:00 CDT












Original text of this message













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