Module org.jooq

Package org.jooq

Interface IfElseStep

All Superinterfaces:

QueryPart, Serializable, Statement

@Pro
public interface IfElseStep
extends Statement

An intermediate step in building a procedural IF statement.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
Statement	else_(Collection<? extends Statement> statements)	Add an ELSE clause to the IF statement.
Statement	else_(Statement... statements)	Add an ELSE clause to the IF statement.
IfThenStep	elsif(Condition condition)	Add an ELSIF clause to the IF statement.

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

elsif

@Support({AURORA_POSTGRES,DB2,H2,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER})
IfThenStep elsif(Condition condition)

Add an ELSIF clause to the IF statement.

else_

@Support({AURORA_POSTGRES,DB2,H2,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER})
Statement else_(Statement... statements)

Add an ELSE clause to the IF statement.

else_

@Support({AURORA_POSTGRES,DB2,H2,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER})
Statement else_(Collection<? extends Statement> statements)

Add an ELSE clause to the IF statement.