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 -> Get a RowID with Oracle 8.1.5

Get a RowID with Oracle 8.1.5

From: Dirk Poppke <poppke_at_iug.cs.uni-dortmund.de>
Date: Thu, 20 Jan 2000 10:06:53 +0100
Message-ID: <866j7d$phd$1@fbi-news.cs.uni-dortmund.de>


Hello!

I've got a simple newbee question:

I wan't to get a unique rowid for a row in a table. Till now, i used a sequence, but the sequence didn't reuse numbers which are set free again (maybe by a delete Statement).

The pseudo - column RowID works easier, but you can't migrate them to another DB.

Is there a better solution than this two ways?

Thanx in advance,
Dirk Received on Thu Jan 20 2000 - 03:06:53 CST

Original text of this message

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