Interface Sequence<T extends Number>

All Superinterfaces:

Named, Qualified, QueryPart, Serializable, Typed<T>

All Known Implementing Classes:

SequenceImpl

public interface Sequence<T extends Number>
extends Qualified, Typed<T>

A sequence.

Instances can be created using DSL.sequence(Name) and overloads.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull Field<T>	currval()	An expression to get the current value of this sequence.
@Nullable Field<T>	getCache()	Get the number of sequence values to cache for this sequence or null, if no such value is specified.
boolean	getCycle()	Returns true if this sequence cycles to getMinvalue() when it reaches getMaxvalue().
@Nullable Field<T>	getIncrementBy()	Get the increment for this sequence or null, if no such value is specified.
@Nullable Field<T>	getMaxvalue()	Get the maximum value for this sequence or null, if no such value is specified.
@Nullable Field<T>	getMinvalue()	Get the minimum value for this sequence or null, if no such value is specified.
@Nullable Field<T>	getStartWith()	Get the start value for this sequence or null, if no such value is specified.
@NotNull Field<T>	nextval()	An expression to increment the sequence and get the next value.
@NotNull Select<Record1<T>>	nextvals(int size)	An expression to increment the sequence and get the next values.

Methods inherited from interface Named

$name, getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface Qualified

$schema, getCatalog, getSchema

Methods inherited from interface QueryPart

$replace, $replace, $traverse, $traverse, equals, hashCode, toString

Methods inherited from interface Typed

$dataType, getBinding, getConverter, getDataType, getDataType, getType

Method Details

getStartWith

@Nullable
@Nullable Field<T> getStartWith()

Get the start value for this sequence or null, if no such value is specified.

getIncrementBy

@Nullable
@Nullable Field<T> getIncrementBy()

Get the increment for this sequence or null, if no such value is specified.

getMinvalue

@Nullable
@Nullable Field<T> getMinvalue()

Get the minimum value for this sequence or null, if no such value is specified.

getMaxvalue

@Nullable
@Nullable Field<T> getMaxvalue()

Get the maximum value for this sequence or null, if no such value is specified.

getCycle

boolean getCycle()

Returns true if this sequence cycles to getMinvalue() when it reaches getMaxvalue().

getCache

@Nullable
@Nullable Field<T> getCache()

Get the number of sequence values to cache for this sequence or null, if no such value is specified.

currval

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA,YUGABYTEDB})
@NotNull Field<T> currval()

An expression to get the current value of this sequence.

nextval

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SNOWFLAKE,SPANNER,SQLSERVER2012,SYBASE,VERTICA,YUGABYTEDB})
@NotNull Field<T> nextval()

An expression to increment the sequence and get the next value.

nextvals

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SNOWFLAKE,SPANNER,SQLSERVER2012,SYBASE,VERTICA,YUGABYTEDB})
@NotNull Select<Record1<T>> nextvals(int size)

An expression to increment the sequence and get the next values.

This is done using DSL.generateSeries(int, int).