Module org.jooq

Package org.jooq

Interface ForInStep<T>

@Pro
public interface ForInStep<T>

The step in the creation of a FOR LOOP statement where the IN clause can be supplied.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull ForByStep<T>	in(Field<T> lower, Field<T> upper)	The range over which to loop.
@NotNull ForByStep<T>	in(T lower, T upper)	The range over which to loop.
@NotNull ForByStep<T>	inReverse(Field<T> upper, Field<T> lower)	The range over which to loop.
@NotNull ForByStep<T>	inReverse(T upper, T lower)	The range over which to loop.

Method Details

in

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB_10_3,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB})
@NotNull ForByStep<T> in(T lower,
 T upper)

The range over which to loop.

This starts with the lower bound and increments the variable until it reaches the upper bound.

Parameters:

lower - The lower bound (inclusive)

upper - The upper bound (inclusive)

in

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB_10_3,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB})
@NotNull ForByStep<T> in(Field<T> lower,
 Field<T> upper)

The range over which to loop.

This starts with the lower bound and increments the variable until it reaches the upper bound.

Parameters:

lower - The lower bound (inclusive)

upper - The upper bound (inclusive)

inReverse

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB_10_3,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB})
@NotNull ForByStep<T> inReverse(T upper,
 T lower)

The range over which to loop.

This starts with the upper bound and decrements the variable until it reaches the lower bound.

Parameters:

upper - The upper bound (inclusive)

lower - The lower bound (inclusive)

inReverse

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB_10_3,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB})
@NotNull ForByStep<T> inReverse(Field<T> upper,
 Field<T> lower)

The range over which to loop.

This starts with the upper bound and decrements the variable until it reaches the lower bound.

Parameters:

upper - The upper bound (inclusive)

lower - The lower bound (inclusive)