Difference between revisions of "OE.ORDERS SEQ (sequence)"

From dbscript Online Help
Jump to: navigation, search
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Sequence
 
| '''Sequence
 
| OE.ORDERS_SEQ
 
| OE.ORDERS_SEQ
|-
 
 
|}
 
|}
 
  
 
=== Sequence ===
 
=== Sequence ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| Start Value
 
| Start Value
 
| 1
 
| 1
|-
+
|- valign="top"
 
| Max. Value
 
| Max. Value
 
|  
 
|  
|-
+
|- valign="top"
 
| Increment
 
| Increment
 
| 1
 
| 1
|-
+
|- valign="top"
 
| Cache Values
 
| Cache Values
 
|  
 
|  
|-
+
|- valign="top"
 
| Cycle
 
| Cycle
 
|  
 
|  
|-
 
 
|}
 
|}
 +
<pre>
 +
CREATE SEQUENCE OE.ORDERS_SEQ
 +
INCREMENT BY 1
 +
START WITH 1
 +
MAXVALUE
 +
CACHE  CYCLE
 +
</pre>

Revision as of 06:15, 24 June 2010

wikibot

Sequence OE.ORDERS_SEQ

Sequence

Start Value 1
Max. Value
Increment 1
Cache Values
Cycle
CREATE SEQUENCE OE.ORDERS_SEQ
INCREMENT BY 1
START WITH 1
MAXVALUE 
CACHE  CYCLE