Search Again: RE : Sequence question From: yvonne Date: Friday, April 30, 2004 Time: 12:29:02 am You get it c) is correct -----Message d'origine----- De=A0: oracle-list@digitalpoint.com = [mailto:oracle-list@digitalpoint.com] De la part de Johnathan Marvin Envoy=E9=A0: jeudi 29 avril 2004 11:23 =C0=A0: ORACLE-APPS-L@OpenITx.com; oracle-list@digitalpoint.com Objet=A0: [Oracle] Sequence question I am stuck with this one... Which of the following SQL statements will generate the next value in the=20 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=20 Premium!=20 http://join.msn.com/?page=3Dfeatures/mlb&pgmarket=3Den-us/go/onm00200439a= ve/ direct/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: RE : Sequence question by yvonne on Apr 30, 2004 at 12:29:02 am