Oracle Sequences and how to create one

By

Here is how to create a sequence and two of the most popular functions
to use on a sequence.

CREATE SEQUENCE <seq_name>
INCREMENT BY <integer>
START WITH <integer>

seq_name.NEXTVAL
seq_name.CURRVAL

Example:
CREATE SEQUENCE MySeq
INCREMENTED BY 1
START WITH 1

Comments

Post a Comment

Popular posts from this blog

Vim vi how to reload a file your editing

By
5.8. How do I reload/re-edit the current file? You can use the ":edit" command, without specifying a file name, to reload the current file. If you have made modifications to the file, you can use ":edit!" to force the reload of the current file (you will lose your modifications). For more information, read :help :edit :help :edit! :help 'confirm' from - http://vimdoc.sourceforge.net/cgi-bin/vimfaq2html3.pl#5.8
Read more