- All Superinterfaces:
Named
,Qualified
,QueryPart
,Serializable
,Typed<T>
- All Known Implementing Classes:
SequenceImpl
A sequence.
Instances can be created using DSL.sequence(Name)
and overloads.
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescriptioncurrval()
An expression to get the current value of this sequence.getCache()
Get the number of sequence values to cache for this sequence ornull
, if no such value is specified.boolean
getCycle()
Get the increment for this sequence ornull
, if no such value is specified.Get the maximum value for this sequence ornull
, if no such value is specified.Get the minimum value for this sequence ornull
, if no such value is specified.Get the start value for this sequence ornull
, if no such value is specified.nextval()
An expression to increment the sequence and get the next value.nextvals
(int size) An expression to increment the sequence and get the next values.Methods inherited from interface org.jooq.Named
$name, getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName
Methods inherited from interface org.jooq.Qualified
$schema, getCatalog, getSchema
Methods inherited from interface org.jooq.QueryPart
$replace, $replace, $traverse, $traverse, equals, hashCode, toString
Methods inherited from interface org.jooq.Typed
$dataType, getBinding, getConverter, getDataType, getDataType, getType
-
Method Details
-
getStartWith
Get the start value for this sequence ornull
, if no such value is specified. -
getIncrementBy
Get the increment for this sequence ornull
, if no such value is specified. -
getMinvalue
Get the minimum value for this sequence ornull
, if no such value is specified. -
getMaxvalue
Get the maximum value for this sequence ornull
, if no such value is specified. -
getCycle
boolean getCycle() -
getCache
Get the number of sequence values to cache for this sequence ornull
, if no such value is specified. -
currval
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,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,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SNOWFLAKE,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,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SNOWFLAKE,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)
.
-