Search Again: Sequence question From: Johnathan Marvin Date: Thursday, April 29, 2004 Time: 3:30:35 am I am stuck with this one... Which of the following SQL statements will generate the next value in the EMP_EMPNO sequence? a) SELECT emp_empno.nextvalue FROM dual; b) SELECT emp_empno.currentvalue FROM dual; c) SELECT emp_empno.nextval FROM dual; d) SELECT emp_empno.currentval FROM dual; I feel that the correct answer is C. Can anyone please confirm this? thanks _________________________________________________________________ Watch LIVE baseball games on your computer with MLB.TV, included with MSN Premium! http://join.msn.com/?page=features/mlb&pgmarket=en-us/go/onm00200439ave/direct/01/ ---------------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.digitalpoint.com/lists/oracle.html ----------------------------------------------------------

Messages In This Thread: Sequence question by Johnathan Marvin on Apr 29, 2004 at 3:30:35 am Re: Sequence question by Shoaib Saleem on Apr 29, 2004 at 9:37:49 pm