oracle.javatools.db.sql

Interface DeclarativeSQLQuery

All Known Implementing Classes:

OracleSQLQuery

Deprecated.

- incorporated in to SQLQuery

@Deprecated
public interface DeclarativeSQLQuery

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	TYPE Deprecated.

Method Summary

Methods

Modifier and Type	Method and Description
void	addFromObject(FromObject f) Deprecated. Add a from object to the end of the list.
void	addFromObject(int index, FromObject f) Deprecated. Add a from object to the given position in the list.
void	addOrderByObject(int index, OrderByObject s) Deprecated. Add a OrderBy object to the given position in the list.
void	addOrderByObject(OrderByObject s) Deprecated. Add a OrderBy object to the end of the list.
void	addSelectObject(int index, SelectObject s) Deprecated. Add a select object to the given position in the list.
void	addSelectObject(SelectObject s) Deprecated. Add a select object to the end of the list.
FromObject[]	getFromObjects() Deprecated. Get all the from objects for this query.
GroupByObject	getGroupByObject() Deprecated. Gets the "GROUP BY ...
HierarchicalQueryObject	getHierarchicalQueryObject() Deprecated. Get the "CONNECT BY ...
OrderByObject[]	getOrderByObjects() Deprecated. Get all the OrderBy objects for this query.
SelectObject[]	getSelectObjects() Deprecated. Get all the select objects for this query.
SetOperator	getSetOperator() Deprecated. Get's first set operator relationship (e.g.
WhereObject	getWhereObject() Deprecated. Gets the WHERE clause for this query.
int	indexOf(FromObject f) Deprecated. 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) Deprecated. 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) Deprecated. Returns the index of the given SelectObject in the query's SELECT clause, or -1 if it isn't in the clause.
boolean	isDeclarative() Deprecated. Tests whether this query has been fully built declaratively - i.e.
void	moveFromObject(FromObject f, int newIndex) Deprecated. Moves the given FromObject within the query's FROM clause.
void	moveOrderByObject(OrderByObject o, int newIndex) Deprecated. Moves the given OrderByObject within the query's ORDER BY clause.
void	moveSelectObject(SelectObject s, int newIndex) Deprecated. Moves the given SelectObject within the query's SELECT clause.
boolean	removeFromObject(FromObject f) Deprecated. Remove a from object from the list.
boolean	removeOrderByObject(OrderByObject s) Deprecated. Remove a OrderBy object from the list.
boolean	removeSelectObject(SelectObject s) Deprecated. Remove a select object from the list.
void	setFromObjects(FromObject[] froms) Deprecated. Set all the from objects for this query.
void	setGroupByObject(GroupByObject groupby) Deprecated. Sets the "GROUP BY ...
void	setHierarchicalQueryObject(HierarchicalQueryObject connectBy) Deprecated. Sets the Hierarchical query clause
void	setOrderByObjects(OrderByObject[] OrderBys) Deprecated. Set all the OrderBy objects for this query.
void	setSelectObjects(SelectObject[] selects) Deprecated. Set all the select objects for this query.
void	setWhereObject(WhereObject where) Deprecated. Sets the WHERE clause for this query.

Field Detail

TYPE

static final java.lang.String TYPE

Deprecated.

See Also:

Constant Field Values

Method Detail

getSelectObjects

SelectObject[] getSelectObjects()

Deprecated.

Get all the select objects for this query.

getFromObjects

FromObject[] getFromObjects()

Deprecated.

Get all the from objects for this query.

getWhereObject

WhereObject getWhereObject()

Deprecated.

Gets the WHERE clause for this query.

getOrderByObjects

OrderByObject[] getOrderByObjects()

Deprecated.

Get all the OrderBy objects for this query.

getHierarchicalQueryObject

HierarchicalQueryObject getHierarchicalQueryObject()

Deprecated.

Get the "CONNECT BY ... START WITH ..." clause for this query

getGroupByObject

GroupByObject getGroupByObject()

Deprecated.

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

getSetOperator

SetOperator getSetOperator()

Deprecated.

Get's first set operator relationship (e.g. a UNION with another query)

isDeclarative

boolean isDeclarative()

Deprecated.

Tests whether this query has been fully built declaratively - i.e. calling getSQLText on the entire query will return the correct query String. Views that aren't fully declarative can still be used for dependency information.

setSelectObjects

void setSelectObjects(SelectObject[] selects)

Deprecated.

Set all the select objects for this query.

addSelectObject

void addSelectObject(SelectObject s)

Deprecated.

Add a select object to the end of the list.

addSelectObject

void addSelectObject(int index,
                   SelectObject s)

Deprecated.

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

removeSelectObject

boolean removeSelectObject(SelectObject s)

Deprecated.

Remove a select object from the list.

moveSelectObject

void moveSelectObject(SelectObject s,
                    int newIndex)

Deprecated.

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)

Deprecated.

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)

Deprecated.

Set all the from objects for this query.

addFromObject

void addFromObject(FromObject f)

Deprecated.

Add a from object to the end of the list.

addFromObject

void addFromObject(int index,
                 FromObject f)

Deprecated.

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

removeFromObject

boolean removeFromObject(FromObject f)

Deprecated.

Remove a from object from the list.

moveFromObject

void moveFromObject(FromObject f,
                  int newIndex)

Deprecated.

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)

Deprecated.

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)

Deprecated.

Sets the WHERE clause for this query.

setHierarchicalQueryObject

void setHierarchicalQueryObject(HierarchicalQueryObject connectBy)

Deprecated.

Sets the Hierarchical query clause

setGroupByObject

void setGroupByObject(GroupByObject groupby)

Deprecated.

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

setOrderByObjects

void setOrderByObjects(OrderByObject[] OrderBys)

Deprecated.

Set all the OrderBy objects for this query.

addOrderByObject

void addOrderByObject(OrderByObject s)

Deprecated.

Add a OrderBy object to the end of the list.

addOrderByObject

void addOrderByObject(int index,
                    OrderByObject s)

Deprecated.

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

removeOrderByObject

boolean removeOrderByObject(OrderByObject s)

Deprecated.

Remove a OrderBy object from the list.

moveOrderByObject

void moveOrderByObject(OrderByObject o,
                     int newIndex)

Deprecated.

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)

Deprecated.

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