Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Difference between ROWNUM & ROWID
Rownum is the reply set row identifier, strictly numeric Rowid is the Oracle internal representation of the exact location of the row (Block#.Row#.File#).
Concatenating indexes is when an index is built upon more than one field/column in the target table. Usually called a concatenated index.
-- Phillip Bump Senior Principal Consultant Oracle Consulting ---------------------------------------------------------------------------- ----------------------------------------------------------------------- The opinions expressed are my own and do not necessarily reflect those of Oracle Corporation SKMGMT <skmgmt_at_aol.com> wrote in article <19970917020100.WAA25417_at_ladder02.news.aol.com>...Received on Sat Sep 20 1997 - 00:00:00 CDT
> CAN someone kindly tell me the difference between the two.
>
> Also what is Concatenating indexes.
>