Re: bind sequences to columns

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 14 Oct 2002 23:07:04 +1000
Message-ID: <b8zq9.52567$g9.153339@newsfeeds.bigpond.com>

Hi Thomas,

A Sequence is an independent object that can't be 'binded' to a specific table or column.

Sorry :(

However, the little question I have is why do you want this ? Providing the sequence is accessed and used appropriately, then it shouldn't really be an issue. If you're afraid of "gaps" in a sequence, then no matter what do you, sequences don't guarantee the absence of gaps (a simple rollback will stuff you up there).

Cheers

Richard
"Thomas" <thomas.hiller_at_warema.de> 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 - 08:07:04 CDT