.plasma-sdo.1.3.3.source-code.query.xsd Maven / Gradle / Ivy
The newest version!
A floating point value between zero (result entity is never included) and 1 (result entity is always included) used to sample or filter results. Cannot be used with with (potentially) many types of predicates depending on the restrictions within the underlying data store.
defines a named configuration property element with simple string content used to pass query specific configuration information to data access services
returns the average of the values in a group. Null values are ignored
returns the number of items in a group
returns the maximum value in the expression
returns the minimum value in the expression
returns the statistical standard deviation of all values in the specified expression
returns the sum of all the values
returns the statistical variance of all values in the specified expression
returns an expression of one data type to another
returns an expression of one data type to another
returns mathematical function that returns the absolute (positive) value of the specified numeric expression
returns mathematical function that returns the angle, in radians, whose cosine is the specified float expression
returns the angle, in radians, whose sine is the specified float expression. This is also called arcsine
returns the angle in radians whose tangent is a specified float expression. This is also called arctangent
returns the smallest integer greater than, or equal to, the specified numeric expression
returns a mathematical function that returns the trigonometric cosine of the specified angle, in radians, in the specified expression
returns mathematical function that returns the trigonometric cotangent of the specified angle, in radians, in the specified float expression
returns the exponential value of the specified float expression
returns the largest integer less than or equal to the specified numeric expression
returns the natural logarithm of the specified float expression
returns the base-10 logarithm of the specified float expression
returns the constant value of PI
returns the value of the specified expression to the specified power
returns a numeric value, rounded to the specified length or precision
returns the trigonometric sine of the specified angle, in radians, and in an approximate numeric, float, expression
returns the square root of the specified float value
returns the square of the specified float value
returns the tangent of the input expression
returns the column precision
returns the column scale
returns the column, table, schema or database name
returns the column, table, schema or database physical name alias
returns the column, table, schema or database business name alias
returns the column, table, schema or database business name alias
returns the rank of each row within the partition of a result set
numbers the output of a result set. More specifically, returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition
returns the system-supplied value for the database user name of the current user