Re: question about sequences.

From: Ryan <rgaffuri_at_cox.net>
Date: Sun, 16 Feb 2003 00:40:13 GMT
Message-ID: <N5B3a.17230$4F3.847357@news2.east.cox.net>

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E4ED03C.D5835E31_at_exesolutions.com...
> Ryan wrote:
>
> > I got a trick question in an interview and I dont know if what I said
was
> > write. It was a written exam so I couldnt ask.
> >
> > Someone does
> >
> > select sequence.nextval
> > from dual;
> >
> > you get two sequence numbers back. All I could think of was that someone
> > inserted a second row into dual.
> >
> > Could any other reason lead to two sequence numbers being returned?
>
> No!
>
> Daniel Morgan
>

figured it was a trick question. Received on Sat Feb 15 2003 - 18:40:13 CST