CREATE SEQUENCE schema_namesequence_name INCREMENT BY interval START WITH first_number MAXVALUE max_value NOMAXVALUE MINVALUE min_value NOMINVALUE CYCLE NOCYCLE CACHE cache_size NOCACHE ORDER NOORDER. CREATE SEQUENCE sequence_1 start with 1 increment by 1 minvalue 0 maxvalue 100 cycle. There was a question from the op regarding adding a new column to a query output by generating the cyclic sequence numbers from 1 to 3.
For small ranges of sequence values you can use something like this.
The ALTER SEQUENCE statement allows you to change the increment minimum value maximum value cached numbers and behavior of a sequence object. A document sequence uniquely numbers documents generated by an Oracle Fusion application. SELECT last_number FROM user_sequences WHERE sequence_name. ValasekdDV10G create sequence t_seq 2 Sequence created.