public class WindowDefinitionClause extends SqlObject
([PARTITION BY <cols>] [ORDER BY <cols>] [<frameClause>])
Can be used inline on a FunctionCall
or via a named reference in a
SelectQuery
.Modifier and Type | Class and Description |
---|---|
static class |
WindowDefinitionClause.FrameBound
Outputs a bound for the window frame clause.
|
static class |
WindowDefinitionClause.FrameExclusion
Outputs the exclusion for the window frame clause.
|
static class |
WindowDefinitionClause.FrameUnits
Outputs the units for the window frame clause.
|
ALL_SYMBOL, NULL_VALUE, QUESTION_MARK
Constructor and Description |
---|
WindowDefinitionClause() |
Modifier and Type | Method and Description |
---|---|
WindowDefinitionClause |
addOrdering(Object columnStr,
OrderObject.Dir dir)
Adds the given column with the given direction to the "ORDER BY"
clause
|
WindowDefinitionClause |
addOrderings(Object... columnStrs)
Adds the given columns to the "ORDER BY" clause
|
WindowDefinitionClause |
addPartitionColumns(Object... columnStrs)
Adds the given columns to the PARTITION BY column list.
|
void |
appendTo(AppendableExt app)
Appends this object to the given AppendableExt.
|
protected void |
collectSchemaObjects(ValidationContext vContext)
Used during Query.validate() calls to collect the dbschema objects
referenced in a query.
|
WindowDefinitionClause |
setFrame(Object frameUnits,
Object frameStart)
Sets the window's "frame" clause to the given units and starting bound.
|
WindowDefinitionClause |
setFrame(Object frameUnits,
Object frameStart,
Object frameExclusion)
Sets the window's "frame" clause to the given units, starting bound, and
exclusion.
|
WindowDefinitionClause |
setFrameBetween(Object frameUnits,
Object frameStart,
Object frameEnd)
Sets the window's "frame" clause to the given units and bound range.
|
WindowDefinitionClause |
setFrameBetween(Object frameUnits,
Object frameStart,
Object frameEnd,
Object frameExclusion)
Sets the window's "frame" clause to the given units, bound range, and
exclusion.
|
collectSchemaObjects, doValidate, toString
toString, toString
public WindowDefinitionClause addPartitionColumns(Object... columnStrs)
Object
-> SqlObject
conversions handled by
Converter.CUSTOM_COLUMN_TO_OBJ
.
public WindowDefinitionClause addOrdering(Object columnStr, OrderObject.Dir dir)
Object
-> SqlObject
conversions handled by
Converter.toCustomColumnSqlObject(Object)
.
public WindowDefinitionClause addOrderings(Object... columnStrs)
Note, NULL ordering can be specified by passing an appropriately
configured instance of OrderObject
to this method.
Object
-> SqlObject
conversions handled by
Converter.CUSTOM_COLUMN_TO_OBJ
.
public WindowDefinitionClause setFrame(Object frameUnits, Object frameStart)
Object
-> SqlObject
conversions handled by
Converter.toCustomSqlObject(java.lang.Object)
.
public WindowDefinitionClause setFrame(Object frameUnits, Object frameStart, Object frameExclusion)
Object
-> SqlObject
conversions handled by
Converter.toCustomSqlObject(java.lang.Object)
.
public WindowDefinitionClause setFrameBetween(Object frameUnits, Object frameStart, Object frameEnd)
Object
-> SqlObject
conversions handled by
Converter.toCustomSqlObject(java.lang.Object)
.
public WindowDefinitionClause setFrameBetween(Object frameUnits, Object frameStart, Object frameEnd, Object frameExclusion)
Object
-> SqlObject
conversions handled by
Converter.toCustomSqlObject(java.lang.Object)
.
protected void collectSchemaObjects(ValidationContext vContext)
SqlObject
collectSchemaObjects
in class SqlObject
vContext
- handle to the current validation contextpublic void appendTo(AppendableExt app) throws IOException
Appendee
appendTo
in interface Appendee
appendTo
in class AppendeeObject
app
- the AppendableExt to which this class should append itselfIOException
- if the append failsCopyright © 2006–2021 OpenHMS. All rights reserved.