|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.5.0) E13403-06 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface DeclarativeSQLQuery
Extension of the SQLQuery interface that allows the query to edited.
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, NOCYCLE, ORDERBY, 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, getWhereObject, isDeclarative |
Methods inherited from interface oracle.javatools.db.sql.SQLFragment |
---|
getSQLText |
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 |
---|
void setSelectObjects(SelectObject[] selects)
void addSelectObject(SelectObject s)
void addSelectObject(int index, SelectObject s)
boolean removeSelectObject(SelectObject s)
void moveSelectObject(SelectObject s, int newIndex)
int indexOf(SelectObject s)
void setFromObjects(FromObject[] froms)
void addFromObject(FromObject f)
void addFromObject(int index, FromObject f)
boolean removeFromObject(FromObject f)
void moveFromObject(FromObject f, int newIndex)
int indexOf(FromObject f)
void setWhereObject(WhereObject where)
void setHierarchicalQueryObject(HierarchicalQueryObject connectBy)
void setGroupByObject(GroupByObject groupby)
void setOrderByObjects(OrderByObject[] OrderBys)
void addOrderByObject(OrderByObject s)
void addOrderByObject(int index, OrderByObject s)
boolean removeOrderByObject(OrderByObject s)
void moveOrderByObject(OrderByObject o, int newIndex)
int indexOf(OrderByObject o)
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.5.0) E13403-06 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |