Re: Basic sequence question

From: Steve Bell <swayne.bell_at_sympatico.ca>
Date: Mon, 19 Feb 2001 13:19:08 GMT
Message-ID: <3A911B38.40709@sympatico.ca>

Hi,
Although it may be common in practice to create a sequence for each table that requires it,
it is not a requirement...you can use one sequence in many tables...it's a seperate database object.

Hth,

Steve

Avery wrote:

> Yes create one for each.
> 
> <u366699218_at_spawnkill.ip-mobilphone.net> wrote in message
> news:l.982311650.1485961914_at_c1026384-a.crvlls1.or.home.com...
> 

>> I'm an Oracle sequence novice. I have several tables with primary
>> key IDs that need to be auto-incremented, and sequences appear to be
>> the best way to do that. My question is, do I need to create a separate
>> sequence object for each table? I would think that I do, so that the
>> objects can 'remember' their current value. Am I correctly
>> interpreting their function?
>>
>> Thanks in advance...
>>
>>
>>
>>
>> --
>> Sent by g from yahoo subpart of com
>> This is a spam protected message. Please answer with reference header.
>> Posted via http://www.usenet-replayer.com/cgi/content/new
> Received on Mon Feb 19 2001 - 07:19:08 CST