Difference between revisions of "HR.DEPARTMENTS SEQ (sequence)"
(2 intermediate revisions by the same user not shown) | |||
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 |
| HR.DEPARTMENTS_SEQ | | HR.DEPARTMENTS_SEQ | ||
− | |||
|} | |} | ||
− | + | === 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 | ||
− | | | + | | |
− | |- | + | |- valign="top" |
| Max. Value | | Max. Value | ||
| | | | ||
− | |- | + | |- valign="top" |
| Increment | | Increment | ||
− | | | + | | |
− | |- | + | |- valign="top" |
| Cache Values | | Cache Values | ||
| | | | ||
− | |- | + | |- valign="top" |
| Cycle | | Cycle | ||
| | | | ||
− | |||
|} | |} | ||
+ | <pre> | ||
+ | CREATE SEQUENCE HR.DEPARTMENTS_SEQ | ||
+ | INCREMENT BY | ||
+ | START WITH | ||
+ | MAXVALUE | ||
+ | CACHE CYCLE | ||
+ | </pre> |