Differences

This shows you the differences between two versions of the page.

--- oracle:sql:sequence:create_sequence [2021/08/11 10:58] – created peter
+++ oracle:sql:sequence:create_sequence [2021/08/11 11:00] (current) – peter
@@ Line 4: / Line 4: @@
 CREATE SEQUENCE sequence-name;
 </code>
+----
+<code sql>
+CREATE SEQUENCE schema_name.sequence_name
+[INCREMENT BY interval]
+[START WITH first_number]
+[MAXVALUE max_value | NOMAXVALUE]
+[MINVALUE min_value | NOMINVALUE]
+[CYCLE | NOCYCLE]
+[CACHE cache_size | NOCACHE]
+[ORDER | NOORDER];
+</code>
+<code sql>
+CREATE SEQUENCE id_seq
+    INCREMENT BY 10
+    START WITH 10
+    MINVALUE 10
+    MAXVALUE 100
+    CYCLE
+    CACHE 2;
+</code>