oracle.javatools.db.sql
Class WindowFunction

java.lang.Object
  oracle.javatools.db.AbstractDBObject
      oracle.javatools.db.AbstractChildDBObject
          oracle.javatools.db.sql.AbstractSQLFragment
              oracle.javatools.db.sql.Operation
                  oracle.javatools.db.sql.Function
                      oracle.javatools.db.sql.WindowFunction

All Implemented Interfaces:

ChildDBObject, DBObject, SQLFragment, Copyable, DynamicPropertySet

public class WindowFunction
extends Function

Subclass of Function for windowing functions (using the OVER syntax).

Nested Class Summary

static class	WindowFunction.BoundType
static class	WindowFunction.ClauseType
static class	WindowFunction.WindowFunctionBound

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

AbstractDBObject.ChildSupport

Field Summary

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, NOCYCLE, ORDERBY, SELECT, STARTWITH, TYPE, WHERE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

WindowFunction()

WindowFunction(java.lang.String func)

Method Summary

DBObject	copyTo(DBObject target, DBObject copyParent, IDPolicy idPolicy) Internal copy method used by the API to perform copy operations.
protected void	copyToImpl(WindowFunction target, DBObject copyParent, IDPolicy idPolicy)
boolean	equals(java.lang.Object obj)
protected boolean	equalsImpl(WindowFunction other)
SQLFragment[]	getBounds()
WindowFunction.ClauseType	getClauseType()
OrderByObject[]	getOrderBy()
SQLFragment[]	getPartitionBy()
java.lang.String	getSQLText() Returns the complete SQL representation for this Function fragment.
void	setBounds(SQLFragment[] bounds)
void	setClauseType(WindowFunction.ClauseType rangeOrRow)
void	setOrderBy(OrderByObject[] frags)
void	setPartitionBy(SQLFragment[] frags)

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

copyToImpl, equalsImpl, getDistinctSource, getDistinctText, getFunction, getOperatorText, getSeparator, getTrimLeader, isDistinct, isGrouping, setDistinct, setDistinctSource, setFunction, setGrouping, setSeparator, setTrimLeader

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

addArgument, addArgument, addArguments, checkArgument, checkNewSize, copyToImpl, equalsImpl, getArgumentCount, getArguments, removeArgument, setArguments, setCommutative, setFunctionFormat

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

appendToBuffer, argsToString, getTextOrNull, getTextOrNull, getType, setParent, surroundWithBrackets, surroundWithBrackets, toString

Methods inherited from class oracle.javatools.db.AbstractChildDBObject

copyToImpl, findParent, getParent

Methods inherited from class oracle.javatools.db.AbstractDBObject

changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyToImpl, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getOwnedObjectsImpl, getProperties, getProperty, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setID, 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

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

Constructor Detail

WindowFunction

public WindowFunction()

WindowFunction

public WindowFunction(java.lang.String func)

Method Detail

setPartitionBy

public void setPartitionBy(SQLFragment[] frags)

getPartitionBy

public SQLFragment[] getPartitionBy()

setOrderBy

public void setOrderBy(OrderByObject[] frags)

getOrderBy

public OrderByObject[] getOrderBy()

setClauseType

public void setClauseType(WindowFunction.ClauseType rangeOrRow)

getClauseType

public WindowFunction.ClauseType getClauseType()

setBounds

public void setBounds(SQLFragment[] bounds)

getBounds

public SQLFragment[] getBounds()

getSQLText

public java.lang.String getSQLText()

Description copied from class: Operation

Returns the complete SQL representation for this Function fragment.

Specified by:

getSQLText in interface SQLFragment

Overrides:

getSQLText in class Operation

Returns:

a string representing the SQL text for this object.

equals

public boolean equals(java.lang.Object obj)

Overrides:

equals in class Function

copyTo

public DBObject copyTo(DBObject target,
                       DBObject copyParent,
                       IDPolicy idPolicy)

Description copied from class: AbstractDBObject

Internal copy method used by the API to perform copy operations. All objects must implement this method if they are instantiable objects. Abstract objects (e.g. Relation) must NOT implement this method. The implementation should delegate to the copyToImpl method to copy the actual properties.

This method does not fix internal reference ids on copy. That is done by the calling DBObject.copyTo(DBObject, IDPolicy) method.

Overrides:

copyTo in class Function

See Also:

DBObject.copyTo(java.lang.Object), DBObject.copyTo(DBObject, boolean), AbstractDBObject.copyToImpl(oracle.javatools.db.AbstractDBObject, oracle.javatools.db.DBObject, oracle.javatools.db.IDPolicy)

equalsImpl

protected boolean equalsImpl(WindowFunction other)

copyToImpl

protected void copyToImpl(WindowFunction target,
                          DBObject copyParent,
                          IDPolicy idPolicy)