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>
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
