Difference between revisions of "HR.DEPARTMENTS SEQ (sequence)"

From dbscript Online Help
Jump to: navigation, search
 
Line 11: Line 11:
 
|- valign="top"
 
|- valign="top"
 
| Start Value
 
| Start Value
| 1
+
|  
 
|- valign="top"
 
|- valign="top"
 
| Max. Value
 
| Max. Value
Line 17: Line 17:
 
|- valign="top"
 
|- valign="top"
 
| Increment
 
| Increment
| 10
+
|  
 
|- valign="top"
 
|- valign="top"
 
| Cache Values
 
| Cache Values
Line 27: Line 27:
 
<pre>
 
<pre>
 
CREATE SEQUENCE HR.DEPARTMENTS_SEQ
 
CREATE SEQUENCE HR.DEPARTMENTS_SEQ
INCREMENT BY 10
+
INCREMENT BY  
START WITH 1
+
START WITH  
MAXVALUE 9990
+
MAXVALUE  
 
CACHE  CYCLE
 
CACHE  CYCLE
 
</pre>
 
</pre>

Latest revision as of 10:33, 27 August 2011

wikibot[edit]

Sequence HR.DEPARTMENTS_SEQ

Sequence[edit]

Start Value
Max. Value
Increment
Cache Values
Cycle
CREATE SEQUENCE HR.DEPARTMENTS_SEQ
INCREMENT BY 
START WITH 
MAXVALUE 
CACHE  CYCLE