oracle.javatools.db.sql
Interface DeclarativeSQLQuery

All Superinterfaces:

ChildDBObject, Copyable, DBObject, DynamicPropertySet, SQLFragment, SQLQuery

All Known Implementing Classes:

OracleSQLQuery

public interface DeclarativeSQLQuery
extends SQLQuery

Extension of the SQLQuery interface that allows the query to edited.

Since:

10.1.3

Field Summary

Fields inherited from interface oracle.javatools.db.sql.SQLQuery

TYPE

Fields inherited from interface oracle.javatools.db.sql.SQLFragment

CONNECTBY, FROM, GROUPBY, HAVING, MODEL, NOCYCLE, ORDERBY, ORDERSIBLINGSBY, PRIOR, SELECT, STARTWITH, WHERE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Method Summary

void	addFromObject(FromObject f) Add a from object to the end of the list.
void	addFromObject(int index, FromObject f) Add a from object to the given position in the list.
void	addOrderByObject(int index, OrderByObject s) Add a OrderBy object to the given position in the list.
void	addOrderByObject(OrderByObject s) Add a OrderBy object to the end of the list.
void	addSelectObject(int index, SelectObject s) Add a select object to the given position in the list.
void	addSelectObject(SelectObject s) Add a select object to the end of the list.
int	indexOf(FromObject f) Returns the index of the given FromObject in the query's FROM clause, or -1 if it isn't in the clause.
int	indexOf(OrderByObject o) Returns the index of the given OrderByObject in the query's ORDER BY clause, or -1 if it isn't in the clause.
int	indexOf(SelectObject s) Returns the index of the given SelectObject in the query's SELECT clause, or -1 if it isn't in the clause.
void	moveFromObject(FromObject f, int newIndex) Moves the given FromObject within the query's FROM clause.
void	moveOrderByObject(OrderByObject o, int newIndex) Moves the given OrderByObject within the query's ORDER BY clause.
void	moveSelectObject(SelectObject s, int newIndex) Moves the given SelectObject within the query's SELECT clause.
boolean	removeFromObject(FromObject f) Remove a from object from the list.
boolean	removeOrderByObject(OrderByObject s) Remove a OrderBy object from the list.
boolean	removeSelectObject(SelectObject s) Remove a select object from the list.
void	setFromObjects(FromObject[] froms) Set all the from objects for this query.
void	setGroupByObject(GroupByObject groupby) Sets the "GROUP BY ...
void	setHierarchicalQueryObject(HierarchicalQueryObject connectBy) Sets the Hierarchical query clause
void	setOrderByObjects(OrderByObject[] OrderBys) Set all the OrderBy objects for this query.
void	setSelectObjects(SelectObject[] selects) Set all the select objects for this query.
void	setWhereObject(WhereObject where) Sets the WHERE clause for this query.

Methods inherited from interface oracle.javatools.db.sql.SQLQuery

getFromObjects, getGroupByObject, getHierarchicalQueryObject, getOrderByObjects, getSelectObjects, getSetOperator, getWhereObject, isDeclarative

Methods inherited from interface oracle.javatools.db.sql.SQLFragment

getSQLText, getStartOffset

Methods inherited from interface oracle.javatools.db.ChildDBObject

getParent, setParent

Methods inherited from interface oracle.javatools.db.DBObject

copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, getType, replaceReferenceIDs, setID, setName

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

getProperties, getProperty, getProperty, setProperties, setProperty

Method Detail

setSelectObjects

void setSelectObjects(SelectObject[] selects)

Set all the select objects for this query.

addSelectObject

void addSelectObject(SelectObject s)

Add a select object to the end of the list.

addSelectObject

void addSelectObject(int index,
                     SelectObject s)

Add a select object to the given position in the list.

removeSelectObject

boolean removeSelectObject(SelectObject s)

Remove a select object from the list.

moveSelectObject

void moveSelectObject(SelectObject s,
                      int newIndex)

Moves the given SelectObject within the query's SELECT clause. If the SelectObject isn't in the query already nothing is done.

indexOf

int indexOf(SelectObject s)

Returns the index of the given SelectObject in the query's SELECT clause, or -1 if it isn't in the clause.

setFromObjects

void setFromObjects(FromObject[] froms)

Set all the from objects for this query.

addFromObject

void addFromObject(FromObject f)

Add a from object to the end of the list.

addFromObject

void addFromObject(int index,
                   FromObject f)

Add a from object to the given position in the list.

removeFromObject

boolean removeFromObject(FromObject f)

Remove a from object from the list.

moveFromObject

void moveFromObject(FromObject f,
                    int newIndex)

Moves the given FromObject within the query's FROM clause. If the FromObject isn't in the query already nothing is done.

indexOf

int indexOf(FromObject f)

Returns the index of the given FromObject in the query's FROM clause, or -1 if it isn't in the clause.

setWhereObject

void setWhereObject(WhereObject where)

Sets the WHERE clause for this query.

setHierarchicalQueryObject

void setHierarchicalQueryObject(HierarchicalQueryObject connectBy)

Sets the Hierarchical query clause

setGroupByObject

void setGroupByObject(GroupByObject groupby)

Sets the "GROUP BY ... HAVING ..." clause for this query.

setOrderByObjects

void setOrderByObjects(OrderByObject[] OrderBys)

Set all the OrderBy objects for this query.

addOrderByObject

void addOrderByObject(OrderByObject s)

Add a OrderBy object to the end of the list.

addOrderByObject

void addOrderByObject(int index,
                      OrderByObject s)

Add a OrderBy object to the given position in the list.

removeOrderByObject

boolean removeOrderByObject(OrderByObject s)

Remove a OrderBy object from the list.

moveOrderByObject

void moveOrderByObject(OrderByObject o,
                       int newIndex)

Moves the given OrderByObject within the query's ORDER BY clause. If the OrderByObject isn't in the query already nothing is done.

indexOf

int indexOf(OrderByObject o)

Returns the index of the given OrderByObject in the query's ORDER BY clause, or -1 if it isn't in the clause.