|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK 11g Release 2 (11.1.2.2.0) E17493-03 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object
oracle.javatools.db.AbstractDBObject
oracle.javatools.db.AbstractChildDBObject
oracle.javatools.db.sql.AbstractSQLFragment
oracle.javatools.db.sql.OrderByObject
public class OrderByObject
Object to wrap each part of the ORDER BY clause of a SQLQuery.
Nested Class Summary |
---|
Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject |
---|
AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport |
Field Summary | |
---|---|
static java.lang.String |
ASC Ascending order (ASC) |
static java.lang.String |
DESC Descending order (DESC) |
static java.lang.String |
NULLS_FIRST Order with null values first. |
static java.lang.String |
NULLS_LAST Order with null values last. |
static java.lang.String |
TYPE |
Fields inherited from class oracle.javatools.db.sql.AbstractSQLFragment |
---|
DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, NEWLINE, SPACE |
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 |
Constructor Summary | |
---|---|
OrderByObject() Constructs and empty ORDER BY object. |
|
OrderByObject(SQLFragment exp) Constructs an ORDER BY object with the given expression and no ordering. |
|
OrderByObject(SQLFragment exp, java.lang.String ordering) Constructs an ORDER BY object with the given expression and ordering constraint (either OrderByObject.DESC or OrderByObject.ASC) |
|
OrderByObject(SQLFragment exp, java.lang.String ordering, java.lang.String nullsOrder) Constructs an ORDER BY object with the given expression, ordering and null ordering. |
Method Summary | |
---|---|
SQLFragment |
getExpression() Gets the expression for this ORDER BY object. |
java.lang.String |
getNullOrdering() Returns whether the ordering of nulls has been set (NULLS_FIRST, NULLS_LAST or null). |
java.lang.String |
getOrder() Gets the ordering for this clause (can be null ). |
java.lang.String |
getSQLText() Returns the SQL for this ORDER BY object. |
java.lang.String |
getType() Returns the type of this object. |
void |
setExpression(SQLFragment exp) Sets the expression for this ORDER BY object. |
void |
setNullOrdering(java.lang.String nullOrdering) Sets the ordering of nulls for this order by object (NULLS_FIRST, NULLS_LAST or null). |
void |
setOrder(java.lang.String order) Sets the ordering of this ORDER BY object. |
Methods inherited from class oracle.javatools.db.sql.AbstractSQLFragment |
---|
appendToBuffer, argsToString, getStartOffset, getTextOrNull, getTextOrNull, setParent, setStartOffset, surroundWithBrackets, surroundWithBrackets, toString |
Methods inherited from class oracle.javatools.db.AbstractChildDBObject |
---|
copyToImpl, findParent, getParent, getProperty, setProperty |
Methods inherited from class oracle.javatools.db.AbstractDBObject |
---|
changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getOwnedObjectsImpl, getProperties, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties |
Methods inherited from class java.lang.Object |
---|
clone, finalize, getClass, notify, notifyAll, wait, wait, wait |
Methods inherited from interface oracle.javatools.db.ChildDBObject |
---|
getParent |
Methods inherited from interface oracle.javatools.db.DBObject |
---|
copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, replaceReferenceIDs, setID, setName |
Methods inherited from interface oracle.javatools.util.DynamicPropertySet |
---|
getProperties, getProperty, getProperty, setProperties, setProperty |
Field Detail |
---|
public static final java.lang.String TYPE
public static final java.lang.String ASC
public static final java.lang.String DESC
public static final java.lang.String NULLS_FIRST
public static final java.lang.String NULLS_LAST
Constructor Detail |
---|
public OrderByObject()
public OrderByObject(SQLFragment exp)
public OrderByObject(SQLFragment exp, java.lang.String ordering)
public OrderByObject(SQLFragment exp, java.lang.String ordering, java.lang.String nullsOrder)
Method Detail |
---|
public java.lang.String getType()
DBObject
getType
in interface DBObject
getType
in class AbstractSQLFragment
public java.lang.String getOrder()
null
).public void setOrder(java.lang.String order)
null
, OrderByObject.ASC
or OrderByObject.DESC
public java.lang.String getNullOrdering()
public void setNullOrdering(java.lang.String nullOrdering)
public SQLFragment getExpression()
public void setExpression(SQLFragment exp)
public java.lang.String getSQLText()
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK 11g Release 2 (11.1.2.2.0) E17493-03 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |