void |
Select.addColumn(java.lang.String columnValue,
Alias alias) |
Add a value column to the select list, for example:
addColumn("5", alias("RESOURCE_TYPE_ID")) can be used for:
SELECT foo, 5 AS RESOURCE_TYPE_ID
FROM ...
|
void |
Select.addColumn(java.lang.String source,
java.lang.String name,
Alias alias) |
Add a single column to the select list, providing an alias for the column
|
SelectAdapter |
SelectAdapter.addColumn(java.lang.String columnValue,
Alias alias) |
Add a column value with a given alias.
|
SelectAdapter |
SelectAdapter.addColumn(java.lang.String source,
java.lang.String name,
Alias alias) |
|
SelectItemColumn |
SelectList.addColumn(java.lang.String columnValue,
Alias alias) |
Add a value column (used to add literals)
|
SelectItemColumn |
SelectList.addColumn(java.lang.String source,
java.lang.String name,
Alias alias) |
|
void |
FromClause.addFrom(Select sub,
Alias alias) |
Add the sub-query as an item in the from list
|
void |
Select.addFrom(Select sub,
Alias alias) |
Add a sub-select statement with an alias to the from-clause
|
void |
FromClause.addInnerJoin(java.lang.String tableName,
Alias alias,
ExpNode joinOnPredicate) |
Add an inner join clause to the FROM items list
|
void |
Select.addInnerJoin(java.lang.String tableName,
Alias alias,
ExpNode joinOnPredicate) |
Add an inner join to the from clause for this select statement.
|
void |
FromClause.addLeftOuterJoin(java.lang.String tableName,
Alias alias,
ExpNode joinOnPredicate) |
Add a left outer join clause to the FROM items list
|
void |
Select.addLeftOuterJoin(java.lang.String tableName,
Alias alias,
ExpNode joinOnPredicate) |
Add a left outer join to the from clause for this select statement.
|
SelectItemSubQuery |
SelectList.addSubQuery(Select subQuery,
Alias alias) |
|
void |
FromClause.addTable(java.lang.String tableName,
Alias alias) |
Add a table to the FROM items list
|
void |
FromClause.addTable(java.lang.String schemaName,
java.lang.String tableName,
Alias alias) |
Add a qualified schema.table with an alias.
|
void |
Select.addTable(java.lang.String tableName,
Alias alias) |
Add a table item with an alias to the from-clause
|
void |
Select.addTable(java.lang.String schemaName,
java.lang.String tableName,
Alias alias) |
Add a schema-qualified table item with an alias to the from clause
|
FromAdapter |
FromAdapter.from(java.lang.String tableName,
Alias alias) |
Add a table with an alias (tab AS foo) to the from clause
returning this FromAdapter ready for the next item
|
FromAdapter |
SelectAdapter.from(Select sub,
Alias alias) |
Add the sub-query select to the FROM clause
|
FromAdapter |
SelectAdapter.from(java.lang.String tableName,
Alias alias) |
Create a from clause for this select statement
|
FromAdapter |
FromAdapter.innerJoin(java.lang.String tableName,
Alias alias,
WhereFragment joinOnPredicate) |
Add an INNER JOIN for the given table
|
FromAdapter |
FromAdapter.leftOuterJoin(java.lang.String tableName,
Alias alias,
WhereFragment joinOnPredicate) |
Add a LEFT OUTER JOIN for the given table
|
void |
SelectItem.setAlias(Alias alias) |
|