Re: question about sequences.

From: FC <flavio_at_tin.it>
Date: Sat, 15 Feb 2003 18:28:31 GMT
Message-ID: <jFv3a.248083$AA2.9553983@news2.tin.it>

I think you picked the right answer.

Bye,
Flavio

"Ryan" <rgaffuri_at_cox.net> wrote in message news:Auv3a.14999$4F3.717379_at_news2.east.cox.net...
> 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?
>
>
Received on Sat Feb 15 2003 - 12:28:31 CST