Re: data loads and unique row ids

From: Nighr <nighr_at_aol.com>
Date: 1997/12/28
Message-ID: <19971228234701.SAA11843@ladder02.news.aol.com>#1/1

In article <66rreh$37c$1_at_nntp1.ba.best.com>, "Kevin" <mccax_at_hotmail.com> writes:

>Subject: data loads and unique row ids

From: "Kevin"
><mccax_at_hotmail.com>

Date: Fri, 12 Dec 1997 11:13:41 -0600

Hi,

I am
>wondering when I use Oracle to load base table data will it create
a unique
>row id for each record that I am loading into the database? If so
what is
>the unique row id based on (Username/Computername)?

Thanks,

-Kevin

If you're using SQL*Loader there is a Sequence function to create unique counter information for loaded rows. The "count" option will check for the largest number in that column. That's probably as close to a "rowid" as you'll get.

--Bob. Received on Sun Dec 28 1997 - 00:00:00 CST