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

Home -> Community -> Usenet -> c.d.o.server -> Re: ROWID is IDENTITY?

Re: ROWID is IDENTITY?

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 28 Sep 2001 15:20:56 GMT
Message-ID: <3bb494e3.3284764078@news.alt.net>


On Wed, 26 Sep 2001 11:35:17 -0700, "Jay Valdez" <jay_at_dontspamme.com> wrote:

>Hello,
>
>As in the previous post. I am an SQL Server person doing some
>experimental/proof of concept work in Oracle.
>
>I just want to know what the equivalent of IDENTITY (automatically
>incrementing Long Int) is Oracle is it ROWID?

As the other posters have pointed out, no.

A ROWID is an identifier that Oracle uses the point to the physical (or logical) location of a row. INDEXes use it, and the like.

Brian Received on Fri Sep 28 2001 - 10:20:56 CDT

Original text of this message

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