A sequence was created with the DDL statement shown below:
CREATE SEQUENCE my_sequence CACHE 10 ORDER
The following statements are successfully executed in sequence through separate database
connections:
CONNECTION1 – VALUES NEXT VALUE FOR my_sequence INTO :con1hvar
CONNECTION2 – VALUES NEXT VALUE FOR my_sequence INTO :con2hvar
CONNECTION1 – VALUES NEXT VALUE FOR my_sequence INTO :con1hvar
What is the current value of the :con1hvar host variable?
A.
2
B.
3
C.
11
D.
30