NOSPELL
(Read-only) The NOSPELL option holds the text that is used for FALSE Boolean values in the output of OLAP DML statements.
The value of the NOSPELL option is the word for "no" in the current language, as specified by the NLS_LANGUAGE option. For example, when NLS_LANGUAGE is set to "American," then the default value of NOSPELL is NO.
Examples
Example 5-80 Seeing the Effect of the NOSPELL Option
Suppose you have a variable called BOOLVAR that currently has a value of NO. When "non" is the word for "no" in the language specified by the NLS_LANGUAGE option,
SHOW boolvar
produces the following output.
non
