Sequence max value: 999999999999999999999999999 : Sequence Value « Sequence « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Sequence
  3. Sequence Value

Sequence max value: 999999999999999999999999999

 

SQL>
SQL>
SQL> -- If you omit the MAXVALUE option, your sequence will automatically default to:
SQL>
SQL>    --  MAXVALUE 999999999999999999999999999
SQL>
SQL> -- So you can simplify your CREATE SEQUENCE command as follows:
SQL>
SQL>     CREATE SEQUENCE mySequence
  2          MINVALUE 1
  3          START WITH 1
  4          INCREMENT BY 1
  5          CACHE 20;

Sequence created.

SQL>
SQL>     select mySequence.nextval from dual;

   NEXTVAL
----------
         1

SQL>
SQL>
SQL>     drop sequence mySequence;

Sequence dropped.

SQL>








Related examples in the same category

1.Use sequence in insert command
2.Sequence current value and next value
3.Get Sequence next value
4.Set sequence max value
5.Use Sequence in a procedure
6.If new value is null use the value from a sequence
7.Automatically including unique sequence numbers during an INSERT.
8.Random value based on sequence