OMBRETRIEVE SEQUENCE

Purpose

To retrieve properties of a sequence.

Prerequisites

In the context of an Oracle Module

Syntax

retrieveSequenceCommand =  OMBRETRIEVE SEQUENCE "QUOTED_STRING" ( GET ( 
          "getPropertiesClause" | "getReferenceIconSetClause" ) | 
          "retrieveColumnClause" )
     getPropertiesClause =  PROPERTIES "(" "propertyNameList" ")"
     getReferenceIconSetClause =  ( REF | REFERENCE ) ICONSET
     retrieveColumnClause =  COLUMN "QUOTED_STRING" GET "getPropertiesClause"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }

Parameters

retrieveSequenceCommand

This clause retrieves properties of a sequence.

getPropertiesClause

This clause retrieves all the 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.

retrieveColumnClause

This clause will retrieve columns.

QUOTED_STRING

Name of the column.

propertyNameList

The list of properties.

SEQUENCE Object

Table 21-1 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.

See Also

OMBRETRIEVE

OMBCREATE SEQUENCE

OMBALTER SEQUENCE

OMBDROP SEQUENCE