Re: Is Sybase 'identity' column implemented in Oracle?

Each row has an Oracle assigned rowid which uniquely identifies the row.  It's not as pretty as setting up a sequence, but you can use it for Updates & deletes (usually in a where or having clause). It's an 18 digit hex # of the form bbbbbbbb.rrr.ffff where b = block, r=row, and f = file #.

Carlton Ellis wrote:
>
> I have an application using Sybase (COBOL programs) which I need to
> implement using Oracle. The data base designer used an 'identity'
> column', ". . . which means Sybase assigns a unique number to that column
> when it is inserted into the table. We use that number then as the
> primary key."
>
> Does Oracle have a facility to automatically assign a unique number to a
> column?
>
> Thanks -
> (I am busily going from IBM SQL/DS to Oracle).
>
> Carty Ellis
> cellis_at_po.brockport.edu
  Received on Fri Jun 28 1996 - 00:00:00 CEST