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