Re: question about sequences.

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 Received on Sat Feb 15 2003 - 17:41:48 CST