-
- All Superinterfaces:
Attachable
,AutoCloseable
,CreateSequenceFinalStep
,DDLQuery
,Flow.Publisher<Integer>
,org.reactivestreams.Publisher<Integer>
,Query
,QueryPart
,RowCountQuery
,Serializable
,Statement
public interface CreateSequenceFlagsStep extends CreateSequenceFinalStep
AQuery
that can create sequences.Referencing
XYZ*Step
types directly from client codeIt is usually not recommended to reference any
XYZ*Step
types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.Drawbacks of referencing the
XYZ*Step
types directly:- They're operating on mutable implementations (as of jOOQ 3.x)
- They're less composable and not easy to get right when dynamic SQL gets complex
- They're less readable
- They might have binary incompatible changes between minor releases
- Author:
- Lukas Eder
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description CreateSequenceFlagsStep
cache(Number value)
Add aCACHE
clause to the sequence definition.CreateSequenceFlagsStep
cache(Field<? extends Number> value)
Add aCACHE
clause to the sequence definition.CreateSequenceFlagsStep
cycle()
Add aCYCLE
clause to the sequence definition.CreateSequenceFlagsStep
incrementBy(Number value)
Add aINCREMENT BY
clause to the sequence definition.CreateSequenceFlagsStep
incrementBy(Field<? extends Number> value)
Add aINCREMENT BY
clause to the sequence definition.CreateSequenceFlagsStep
maxvalue(Number value)
Add aMAXVALUE
clause to the sequence definition.CreateSequenceFlagsStep
maxvalue(Field<? extends Number> value)
Add aMAXVALUE
clause to the sequence definition.CreateSequenceFlagsStep
minvalue(Number value)
Add aMINVALUE
clause to the sequence definition.CreateSequenceFlagsStep
minvalue(Field<? extends Number> value)
Add aMINVALUE
clause to the sequence definition.CreateSequenceFlagsStep
noCache()
Add aNO CACHE
clause to the sequence definition.CreateSequenceFlagsStep
noCycle()
Add aNO CYCLE
clause to the sequence definition.CreateSequenceFlagsStep
noMaxvalue()
Add aNO MAXVALUE
clause to the sequence definition.CreateSequenceFlagsStep
noMinvalue()
Add aNO MINVALUE
clause to the sequence definition.CreateSequenceFlagsStep
startWith(Number value)
Add aSTART WITH
clause to the sequence definition.CreateSequenceFlagsStep
startWith(Field<? extends Number> value)
Add aSTART WITH
clause to the sequence definition.-
Methods inherited from interface org.jooq.Attachable
attach, configuration, detach
-
Methods inherited from interface java.util.concurrent.Flow.Publisher
subscribe
-
Methods inherited from interface org.jooq.Query
bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, poolable, queryTimeout
-
-
-
-
Method Detail
-
startWith
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep startWith(Number value)
Add aSTART WITH
clause to the sequence definition.
-
startWith
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep startWith(Field<? extends Number> value)
Add aSTART WITH
clause to the sequence definition.
-
incrementBy
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep incrementBy(Number value)
Add aINCREMENT BY
clause to the sequence definition.
-
incrementBy
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep incrementBy(Field<? extends Number> value)
Add aINCREMENT BY
clause to the sequence definition.
-
minvalue
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep minvalue(Number value)
Add aMINVALUE
clause to the sequence definition.
-
minvalue
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep minvalue(Field<? extends Number> value)
Add aMINVALUE
clause to the sequence definition.
-
noMinvalue
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep noMinvalue()
Add aNO MINVALUE
clause to the sequence definition.
-
maxvalue
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep maxvalue(Number value)
Add aMAXVALUE
clause to the sequence definition.
-
maxvalue
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep maxvalue(Field<? extends Number> value)
Add aMAXVALUE
clause to the sequence definition.
-
noMaxvalue
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep noMaxvalue()
Add aNO MAXVALUE
clause to the sequence definition.
-
cycle
@Support({AURORA_POSTGRES,CUBRID,DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep cycle()
Add aCYCLE
clause to the sequence definition.
-
noCycle
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep noCycle()
Add aNO CYCLE
clause to the sequence definition.
-
cache
@Support({AURORA_POSTGRES,CUBRID,DB2,H2,HANA,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep cache(Number value)
Add aCACHE
clause to the sequence definition.
-
cache
@Support({AURORA_POSTGRES,CUBRID,DB2,H2,HANA,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep cache(Field<? extends Number> value)
Add aCACHE
clause to the sequence definition.
-
noCache
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) CreateSequenceFlagsStep noCache()
Add aNO CACHE
clause to the sequence definition.
-
-