Which of the following is a valid SQL statement when referencing a sequence?
A) INSERT INTO orderitems
VALUES (currval,1,811794939,1);
B) INSERT INTO orderitems
VALUES (currentval,1,811794939,1);
C) INSERT INTO orderitems
VALUES (nextvalue,1,811794939,1);
D) none of the above

Question

Which of the following is a valid SQL statement when referencing a sequence?
A) ​INSERT INTO orderitems
VALUES (currval,1,811794939,1);​
B) ​INSERT INTO orderitems
VALUES (currentval,1,811794939,1);​
C) ​INSERT INTO orderitems
VALUES (nextvalue,1,811794939,1);​
D) none of the above

Quizplus · Accepted Answer

The correct syntax to reference a sequence in SQL for an INSERT statement typically involves the sequence's NEXTVAL or CURRVAL functions, but the syntax provided in options A, B, and C is incorrect, making D the correct choice.

Which of the Following Is a Valid SQL Statement When