Differences

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

--- oracle:sql:sequence [2021/08/11 10:57] – created peter
+++ oracle:sql:sequence [2021/08/11 11:08] (current) – peter
@@ Line 1: / Line 1: @@
 ====== Oracle - SQL - Sequence ======
+A sequence is a user-defined schema bound object that generates a sequence of numeric values according to the specification with which the sequence was created.
+  * The sequence of numeric values is generated in an ascending or descending order at a defined interval and can be configured to restart (cycle) when exhausted.
+  * Sequences, unlike identity columns, are not associated with specific tables.
+----
 [[Oracle:SQL:Sequence:Create Sequence|Create Sequence]]
+[[Oracle:SQL:Sequence:Get Current Sequence Value|Get Current Sequence Value]]
+[[Oracle:SQL:Sequence:Get Next Sequence Value|Get Next Sequence Value]]
+[[Oracle:SQL:Sequence:Using a Sequence in a Table Column|Using a Sequence in a Table Column]]