Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The SQRT function computes the square root of an expression.
DECIMAL
SQRT(expression)
The numeric expression whose square root is to be computed.
OLADM1906Negative 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
.
OLADM1907Example 8-104 Calculating a Square Root
This example calculates the square root of 144
. The statement
SHOW SQRT(144)
produces the following result.
12.00