../E14406-01.epub /> ../E14406-01.mobi />

OMBCREATE SEQUENCE

Purpose

To create a sequence.

Prerequisites

In the context of an Oracle Module.

Syntax

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" )

Parameters

createSequenceCommand

This command creates a sequence.

setPropertiesClause

Used to set properties (core, logical, physical, user-defined) for sequences., columns, unique keys, foreign keys, primary keys, and check constraints.

getPropertiesClause

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.

propertyNameList

The list of properties.

propertyValueList

The list of property values.

propertyValue

This clause adds the property values.

SEQUENCE Object

Table 9-98 SEQUENCE Object

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.