(Read-only) The YESSPELL option holds the text that is used for TRUE Boolean values in the output of OLAP DML statements.
The value of the YESSPELL option is the word for "yes" in the current language, as specified by the NLS_LANGUAGE option. (See NLS Options.) For example, when NLS_LANGUAGE is set to American, then the value of YESSPELL is YES. When NLS_LANGUAGE is set to Spanish, then the value of YESSPELL is SI.
Example 26-45 Seeing the Effect of the YESSPELL Value
Suppose you have a variable called BOOLVAR that currently has a value of YES. When "si" is the word for "yes" in the language specified by the NLS_LANGUAGE option,