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

Packages that use SqlStatement.Select
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
 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
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
 



Copyright © 2012 Apache Software Foundation. All Rights Reserved.