Uses of Class
org.apache.oozie.util.db.SqlStatement.Select

Packages that use SqlStatement.Select

Package	Description
org.apache.oozie.util.db

Uses of SqlStatement.Select in org.apache.oozie.util.db

Methods in org.apache.oozie.util.db that return SqlStatement.Select

Modifier and Type	Method and Description
SqlStatement.Select	SqlStatement.Select.forUpdate() Set the "for update" flag to lock the rows for updating
static SqlStatement.Select	SqlStatement.getCount(Schema.Table... tables) Select count(*) Statement generator.
SqlStatement.Select	SqlStatement.Select.limit(int offset, int limit) Setting the offset and limit for LIMIT clause
SqlStatement.Select	SqlStatement.Select.orderBy(Schema.Column column, boolean order) Sets the column to sort and the order of sort
SqlStatement.Select	SqlStatement.Select.orderBy(Schema.Column column0, boolean order0, Schema.Column column1, boolean order1) To sort 2 columns
static SqlStatement.Select	SqlStatement.selectAllFrom(Schema.Table... tables) Return a Select All Statement
static SqlStatement.Select	SqlStatement.selectColumns(Schema.Column... columns) Return a Select Statement
SqlStatement.Select	SqlStatement.Select.where(SqlStatement.Condition condition) Set the condition for where clause

Methods in org.apache.oozie.util.db with parameters of type SqlStatement.Select

Modifier and Type	Method and Description
static SqlStatement.Condition	SqlStatement.in(Schema.Column column, SqlStatement.Select select) Sub query with IN condition
static SqlStatement.Condition	SqlStatement.notIn(Schema.Column column, SqlStatement.Select select) Sub query with NOT IN condition