oracle.javatools.db.sql

Class GroupByObject

java.lang.Object

oracle.javatools.db.AbstractDBObject

oracle.javatools.db.AbstractBuildableObject

oracle.javatools.db.AbstractChildBuildableObject

oracle.javatools.db.sql.AbstractSQLFragment

oracle.javatools.db.sql.GroupByObject

All Implemented Interfaces:

ChildDBObject, DBObject, SQLFragment, Copyable

public class GroupByObject
extends AbstractSQLFragment

SQLFragment for the GROUP BY ... HAVING ... clause in a SQLQuery.

Since:

10.1.3

Nested Class Summary

Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject

AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport

Field Summary

Fields

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

Fields inherited from class oracle.javatools.db.sql.AbstractSQLFragment

AS, COMMA, DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, INDENT, LEFT_PAREN, NEWLINE, RIGHT_PAREN, 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

Constructors

Constructor and Description
GroupByObject()
GroupByObject(SQLFragment[] exps)
GroupByObject(SQLFragment[] exps, WhereObject having)

Method Summary

Modifier and Type	Method and Description
void	addExpression(int index, SQLFragment s)
void	addExpression(SQLFragment s)
SQLFragment[]	getExpressions()
WhereObject	getHaving()
java.lang.String	getSQLText() Return the SQL for this fragment.
java.lang.String	getType() Returns the type of this object.
void	moveExpression(SQLFragment s, int newIndex)
boolean	removeExpression(SQLFragment s)
void	setExpressions(SQLFragment[] exps)
void	setHaving(WhereObject having)

Methods inherited from class oracle.javatools.db.sql.AbstractSQLFragment

appendToBuffer, appendToBuffer, argsToString, getName, getStartOffset, getTextOrNull, getTextOrNull, setStartOffset, surroundWithBrackets, surroundWithBrackets, toString

Methods inherited from class oracle.javatools.db.AbstractChildBuildableObject

setParent

Methods inherited from class oracle.javatools.db.AbstractBuildableObject

checkInit, checkInit, copyToImpl, getOwnedObjectsImpl, getProperties, getReferenceIDsImpl, needsInitialization, processPropertyChange, setID

Methods inherited from class oracle.javatools.db.AbstractDBObject

addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, fireObjectUpdated, firePropertyChanged, getChildSupport, getChildSupport, getID, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setName, setProperties, setProperty

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface oracle.javatools.db.ChildDBObject

getParent, setParent

Methods inherited from interface oracle.javatools.db.DBObject

addObjectListener, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, getID, getOwnedObjects, getOwnedObjects, getProperties, getProperty, getProperty, getReferenceIDs, hashCode, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName, setProperties, setProperty

Field Detail

TYPE

public static final java.lang.String TYPE

See Also:

Constant Field Values

Constructor Detail

GroupByObject

public GroupByObject()

GroupByObject

public GroupByObject(SQLFragment[] exps)

GroupByObject

public GroupByObject(SQLFragment[] exps,
                     WhereObject having)

Method Detail

getType

public java.lang.String getType()

Description copied from interface: DBObject

Returns the type of this object. Valid types include things like tables, views, synonyms, and columns.

Specified by:

getType in interface DBObject

Overrides:

getType in class AbstractSQLFragment

Returns:

a string describing the type of object.

setHaving

public void setHaving(WhereObject having)

getHaving

public WhereObject getHaving()

getExpressions

public SQLFragment[] getExpressions()

setExpressions

public void setExpressions(SQLFragment[] exps)

addExpression

public void addExpression(SQLFragment s)

addExpression

public void addExpression(int index,
                          SQLFragment s)

removeExpression

public boolean removeExpression(SQLFragment s)

moveExpression

public void moveExpression(SQLFragment s,
                           int newIndex)

getSQLText

public java.lang.String getSQLText()

Description copied from interface: SQLFragment

Return the SQL for this fragment. This contains no validation - if the implementation is incomplete it will just return what it has. Error checking of fragments should be done using a SQLQueryBuilder.

Returns:

a string representing the SQL text for this object.