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.FromPolicy
static class	WindowFunction.NullPolicy
static class	WindowFunction.WindowFunctionBound

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

AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport

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

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

WindowFunction()

WindowFunction(java.lang.String func)

Method Summary

SQLFragment[]	getBounds()
WindowFunction.ClauseType	getClauseType()
WindowFunction.FromPolicy	getFromPolicy()
WindowFunction.NullPolicy	getNullPolicy()
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 clauseType)
void	setFromPolicy(WindowFunction.FromPolicy fromPolicy)
void	setNullPolicy(WindowFunction.NullPolicy nullPolicy)
void	setOrderBy(OrderByObject[] frags)
void	setPartitionBy(SQLFragment[] frags)

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

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, getStartOffset, getTextOrNull, getTextOrNull, getType, setParent, setStartOffset, surroundWithBrackets, surroundWithBrackets, toString

Methods inherited from class oracle.javatools.db.AbstractChildDBObject

findParent, getParent, getProperty, setProperty

Methods inherited from class oracle.javatools.db.AbstractDBObject

changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, 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

Constructor Detail

WindowFunction

public WindowFunction()

WindowFunction

public WindowFunction(java.lang.String func)

Method Detail

setFromPolicy

public void setFromPolicy(WindowFunction.FromPolicy fromPolicy)

getFromPolicy

public WindowFunction.FromPolicy getFromPolicy()

setNullPolicy

public void setNullPolicy(WindowFunction.NullPolicy nullPolicy)

getNullPolicy

public WindowFunction.NullPolicy getNullPolicy()

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 clauseType)

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.