Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: bind sequences to columns
On 14 Oct 2002 12:27:53 -0700, JusungYang_at_yahoo.com (Jusung Yang)
wrote:
>Maybe you are looking for something like the "identity" functionality
>in SQL server, where the value of a column is automatically
>incremented when a new row is inserted? You will have to use trigger
>and sequence for that with ORACLE.
>
>
>- Jusung Yang
>
>
>thomas.hiller_at_warema.de (Thomas) wrote in message news:<6e366956.0210140406.797e4d4c_at_posting.google.com>...
>> Hi *,
>>
>> is there any possibility to bind a sequence to a specific column of a
>> table. I know that Oracle 7.3 does not provide any function like that,
>> but how about Oracle 9i (9.2)
>>
>> regard
>> thomas
It would be nice if a column could have a sequence.next_val as the default value.
Hans Erik Busk
tbf_at_cn.stam.dk
Received on Wed Oct 16 2002 - 07:01:26 CDT