|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.6.0) E13403-07 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
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
public class Function
Subclass of Operation for functions. This generic fragment can have any function name, it is not restrictive to only database supported functions. If the function is a grouping function then the appropriate boolean property will be set.
Nested Class Summary |
---|
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 | |
---|---|
Function()
Creates a new, empty, Function. |
|
Function(java.lang.String function,
SQLFragment[] arguments)
Creates a the given function with arguments. |
|
Function(java.lang.String function,
SQLFragment[] arguments,
boolean grouping)
Creates a the given function with arguments, and boolean to mark whether the function is a grouping function or not. |
|
Function(java.lang.String function,
SQLFragment[] arguments,
java.lang.String separator)
Creates a the given function with arguments and separator. |
|
Function(java.lang.String function,
SQLFragment[] arguments,
java.lang.String separator,
boolean grouping)
Creates a the given function with arguments, and boolean to mark whether the function is a grouping function or not. |
Method Summary | |
---|---|
java.lang.String |
getDistinctSource()
Returns the source string used to set the DISTINCT/UNIQUE/ALL property of the function. |
protected java.lang.String |
getDistinctText()
Override this for aggregate functions which may take a DISTINCT/UNIQUE/ALL qualifier. |
java.lang.String |
getFunction()
Gets the function (text). |
protected java.lang.String |
getOperatorText()
|
java.lang.String |
getSeparator()
|
java.lang.String |
getTrimLeader()
Returns whether this is a trim function with LEADING/TRAILING/BOTH text. |
boolean |
isDistinct()
Returns whether this function is UNIQUE/DISTINCT. |
boolean |
isGrouping()
Returns whether this is a grouping function or not. |
void |
setDistinct(boolean distinct)
Sets whether or not this is a DISTICT/UNIQUE function |
void |
setDistinctSource(java.lang.String distinctSource)
Set the source string used to define the DISTINCT/UNIQUE/ALL and trim LEADING/TRAILING/BOTH property of the function. |
void |
setFunction(java.lang.String function)
Sets the function (text). |
void |
setGrouping(boolean grouping)
Sets whether this is a grouping function or not. |
void |
setSeparator(java.lang.String string)
|
void |
setTrimLeader(java.lang.String trimLeader)
Sets whether this is a trim function with LEADING/TRAILING/BOTH text. |
Methods inherited from class oracle.javatools.db.sql.Operation |
---|
addArgument, addArgument, addArguments, checkArgument, checkNewSize, copyToImpl, equalsImpl, getArgumentCount, getArguments, getSQLText, 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 |
---|
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 |
---|
public Function()
public Function(java.lang.String function, SQLFragment[] arguments)
public Function(java.lang.String function, SQLFragment[] arguments, java.lang.String separator)
public Function(java.lang.String function, SQLFragment[] arguments, boolean grouping)
public Function(java.lang.String function, SQLFragment[] arguments, java.lang.String separator, boolean grouping)
Method Detail |
---|
public java.lang.String getFunction()
public void setFunction(java.lang.String function)
public boolean isGrouping()
public void setGrouping(boolean grouping)
public boolean isDistinct()
For example count(distinct sal) returns a count of the unique sal's
public void setDistinct(boolean distinct)
public java.lang.String getTrimLeader()
public void setTrimLeader(java.lang.String trimLeader)
public java.lang.String getDistinctSource()
public void setDistinctSource(java.lang.String distinctSource)
protected java.lang.String getDistinctText()
Operation
getDistinctText
in class Operation
protected java.lang.String getOperatorText()
getOperatorText
in class Operation
public java.lang.String getSeparator()
getSeparator
in class Operation
public void setSeparator(java.lang.String string)
setSeparator
in class Operation
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.6.0) E13403-07 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |