OMBALTER SEQUENCE

Purpose

To alter properties and definition of a sequence.

Prerequisites

In the context of an Oracle Module.

Syntax

alterSequenceCommand =  OMBALTER ( SEQUENCE "QUOTED_STRING" ( 
          "renameClause" [ "alterPropertiesOrIconSetClause" ] { MODIFY 
          "modifySequenceColumnClause" } | "alterPropertiesOrIconSetClause" { 
          MODIFY "modifySequenceColumnClause" } | ( MODIFY 
          "modifySequenceColumnClause" )+ ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     alterPropertiesOrIconSetClause =  SET ( "setPropertiesClause" [ SET ( REF |
           REFERENCE ) "setReferenceIconSetClause" | UNSET ( REF | REFERENCE ) 
          "unsetReferenceIconSetClause" ] | ( REF | REFERENCE ) 
          "setReferenceIconSetClause" ) | UNSET ( REF | REFERENCE ) 
          "unsetReferenceIconSetClause"
     modifySequenceColumnClause =  COLUMN "QUOTED_STRING" SET 
          "setPropertiesClause"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ICONSET
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterSequenceCommand

This clause is for sequence alter command.

renameClause

renames a table with a different name.

modifySequenceColumnClause

This clause modifies the sequence's column.

setPropertiesClause

set sequences properties.

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 4-53 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.