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
ForByStep<T>	in(Field<T> lower, Field<T> upper)	The range over which to loop.
ForByStep<T>	in(T lower, T upper)	The range over which to loop.
ForByStep<T>	inReverse(Field<T> upper, Field<T> lower)	The range over which to loop.
ForByStep<T>	inReverse(T upper, T lower)	The range over which to loop.

Method Detail

in

@Support({AURORA_POSTGRES,DB2,H2,MARIADB_10_3,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER})
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

@Support({AURORA_POSTGRES,DB2,H2,MARIADB_10_3,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER})
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

@Support({AURORA_POSTGRES,DB2,H2,MARIADB_10_3,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER})
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

@Support({AURORA_POSTGRES,DB2,H2,MARIADB_10_3,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER})
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)