How would you select the current value of the sequence s_id_seq?
A)DISPLAY s_id_seq.CURRVAL;
B)SELECT s_id_seq.CURRVAL;
C)SELECT s_id_seq.CURRVAL FROM DUAL;
D)SHOW s_id_seq.CURRVAL

Question

Quizplus · Accepted Answer

To select the current value of a sequence, we use SELECT statement with the sequence name followed by .CURRVAL. We also need to use the from clause with DUAL table. This is because some databases require the from clause to work with SELECT statement even if no table is selected. Therefore, the correct syntax to select the current value of the sequence is SELECT s_id_seq.CURRVAL FROM DUAL.

How Would You Select the Current Value of the Sequence