Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01 |
|
|
Mobi · ePub |
createSequenceCommand = OMBCREATE ( SEQUENCE "QUOTED_STRING" [ SET ( "setPropertiesClause" [ SET ( REF | REFERENCE ) "setReferenceIconSetClause" ] | ( REF | REFERENCE ) "setReferenceIconSetClause" ) ] ) setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")" setReferenceIconSetClause = ICONSET "QUOTED_STRING" propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" } propertyValueList = "propertyValue" { "," "propertyValue" } propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" )
Used to set properties (core, logical, physical, user-defined) for sequences., columns, unique keys, foreign keys, primary keys, and check constraints.
Basic properties for SEQUENCE: Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of the sequence. Name: CURRVAL Type: NUMBER Valid Values: Any valid character string in supported character set. Default: 1 current increment value. Name: NEXTVAL Type: NUMBER Valid Values: Any valid character string in supported character set. Default: 1 next increment value. next increment value.
Property | Type | Choices | Min | Max | Default | Description |
---|---|---|---|---|---|---|
DEPLOYABLE |
BOOLEAN |
true, false |
none |
none |
true |
Description not available. |
GENERATION_COMMENTS |
STRING |
none |
none |
none |
empty string |
Enter additional comments for the generated code. |
INCREMENT_BY |
NUMBER |
none |
-2147483648 |
2147483647 |
1 |
Description not available. |
START_WITH |
NUMBER |
none |
-2147483648 |
2147483647 |
1 |
Description not available. |