Re: Generation of automatic unique identifier such as CUSTOMER_ID

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 16 Mar 2003 16:01:12 +0100
Message-ID: <7a497vcmdkh1b8craa3edan4chv5s9dgmq_at_4ax.com>


On 16 Mar 2003 06:03:03 -0800, timbono1_at_hotmail.com (Tim Corke) wrote:

>Any ideas???

Read up on sequences in your manual or one of the thousands of examples of using sequences in the groups archives at groups.google.com, to avoid the code you posted. Just
select <sequence>.nextval into <key_column> from dual and you're there.
Your solution is also non-scalable.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Mar 16 2003 - 16:01:12 CET

Original text of this message