The ALTER SEQUENCE statement can affect only the future sequence numbers
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALU...
- Within a single SQL statement, Oracle will increment the sequence only twice for each row.
- The following statements are executed: create sequence my_seq; select my_seq.nextval from dual; select my_s...
- Which of the following is a valid statement for Sequences
- Sequence values cannot be cached.
- ---------------- IS USED TO SEQUENCE DATABASE AND IT CAN NOT BE CHANGED.
- Which clause of the CREATE SEQUENCE statement will cause the sequence to continue to generate numbers even ...
- MAXVALUE is a valid parameter for sequence creation.