Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-02 |
|
|
View PDF |
The SQRT command computes the square root of an expression.
Return Value
DECIMAL
Syntax
SQRT(expression)
Arguments
The numeric expression whose square root is to be computed.
Notes
Negative Expressions
When expression is negative and ROOTOFNEGATIVE is set to NO
, an error occurs. When expression is negative and ROOTOFNEGATIVE is set to YES
, SQRT returns the value NA
.
Examples