Search Again: Re: Sequence question From: Shoaib Saleem Date: Thursday, April 29, 2004 Time: 9:37:49 pm Marvin i think if u r an Oracle guy then u must not ask these type of silly questions ... anyway the answer is C u r rite. Shoaib- ----- Original Message ----- From: "Johnathan Marvin" <americo74@hotmail.com> To: <ORACLE-APPS-L@OpenITx.com>; <oracle-list@digitalpoint.com> Sent: Thursday, April 29, 2004 3:23 PM Subject: [Oracle] Sequence question > 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/dire ct/01/ > > > ---------------------------------------------------------- > To subscribe, unsubscribe or to search list archive > please visit http://www.digitalpoint.com/lists/oracle.html > ---------------------------------------------------------- ---------------------------------------------------------- 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