Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: bind sequences to columns

Re: bind sequences to columns

From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 14 Oct 2002 12:27:53 -0700
Message-ID: <130ba93a.0210141127.7f3c800b@posting.google.com>


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.

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
Received on Mon Oct 14 2002 - 14:27:53 CDT

Original text of this message

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