Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E1712205 


View PDF 
The ROOTOFNEGATIVE option determines the result of any attempt to obtain a root of a negative number.
Data Type
BOOLEAN
Syntax
ROOTOFNEGATIVE = YESNO
Parameters
Allows any attempt to obtain a root of a negative number. Consequently, a statement that attempts to obtain a root of a negative number executes without an error; however, the result of the attempt to obtain the root is NA
. When you are working with a dimensioned variable or expression, setting ROOTOFNEGATIVE to YES
enables you to obtain the root of most of the expression's values when a few of the values might be negative.
(Default) Disallows any attempt to obtain a root of a negative number. Any statement that attempts to obtain a root of a negative number stops executing and an error message is produced.
Usage Notes
Raising to a Noninteger Power
Raising a number to a noninteger power (for example, 5 ** 0.3
or 14 ** 2.7
) is an attempt to obtain a root.
Examples
Example 596 The Effect of ROOTOFNEGATIVE
The following example shows the effect of changing the value of the ROOTOFNEGATIVE option. The variable TESTNUMBER has a value of 56
. When you execute a SHOW statement such as the following one, without changing the ROOTOFNEGATIVE option from its default value of NO
, an attempt is made to obtain the square root and then an error message is produced.
SHOW SQRT(testnumber)
When you change ROOTOFNEGATIVE to YES
, the same statement executes without error
ROOTOFNEGATIVE = YES SHOW SQRT(testnumber)
and produces the following result.
NA