oracle.javatools.db.sql

Class WindowFunction

java.lang.Object

oracle.javatools.db.AbstractDBObject

oracle.javatools.db.AbstractBuildableObject

oracle.javatools.db.AbstractChildBuildableObject

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

Nested Classes

Modifier and Type	Class and Description
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

COMMA, DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, INDENT, 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

Constructors

Constructor and Description
WindowFunction()
WindowFunction(java.lang.String func)

Method Summary

Methods

Modifier and Type	Method and Description
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, setStartOffset, surroundWithBrackets, surroundWithBrackets, toString

Methods inherited from class oracle.javatools.db.AbstractChildBuildableObject

setParent

Methods inherited from class oracle.javatools.db.AbstractBuildableObject

checkInit, checkInit, fireObjectUpdated, getOwnedObjectsImpl, getProperties, getReferenceIDsImpl, needsInitialization

Methods inherited from class oracle.javatools.db.AbstractDBObject

addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, firePropertyChanged, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, 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, setParent

Methods inherited from interface oracle.javatools.db.DBObject

addObjectListener, copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getProperties, getReferenceIDs, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

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.