on
   such a sequence will not be noticed by other sessions until they
   have used up any preallocated values they have cached.
  </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN72324"
></A
><H2
>Examples</H2
><P
>   Create an ascending sequence called <TT
CLASS="LITERAL"
>serial</TT
>, starting at 101:
</P><PRE
CLASS="PROGRAMLISTING"
>CREATE SEQUENCE serial START 101;</PRE
><P>
  </P
><P
>   Select the next number from this sequence:
</P><PRE
CLASS="PROGRAMLISTING"
>SELECT nextval('serial');

 nextval
----