Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Basic sequence question
The advantage of creating one sequence for all your is you have a then unique identifier for all the object in you database. It might not be useful now, but it doesn't cost anything, and could pay off in spades later.
"Steve Bell" <swayne.bell_at_sympatico.ca> wrote in message
news:3A911B38.40709_at_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 - 12:06:16 CST