Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> question about sequences.
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:17:04 CST