| Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-03 |
|
|
View PDF |
| Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-03 |
|
|
View PDF |
(Read-only) The SESSION_NLS_LANGUAGE option is an OLAP session-wide, option that holds the value of NLS_LANGUAGE when the value of STATIC_SESSION_LANGUAGE is NO; or, when the value of STATIC_SESSION_LANGUAGE is YES, the value of NLS_LANGUAGE the last time that the value of STATIC_SESSION_LANGUAGE was NO.
See also:
"Working with Language Dimensions", $DEFAULT_LANGUAGE, LOCK_LANGUAGE_DIMS, and STATIC_SESSION_LANGUAGE, "NLS Options"Data type
TEXT
Syntax
SESSION_NLS_LANGUAGE
Examples
For examples of retrieving how the value of SESSION_NLS_LANGUAGE is impacted by changes in the value of NLS_LANGUAGE and STATIC_SESSION_LANGUAGE, see Example 8-9, "Changing NLS_LANGUAGE" and Example 24-43, "Changing NLS_LANGUAGE Without Changing the Language of the OLAP Session".
Example 23-22 SESSION_NLS_LANGUAGE is a Session-Wide Option
Assume that you have two analytic workspace, one named myaw3 and another named myaw4. Assume also, as shown in the following code, that they both have language dimensions named mylangs and that the languages for mylangs in myaw3are American and French and that the languages for mylangs in myaw4 are American and German.
REPORT myaw3!mylangs MYLANGS -------------- AMERICAN FRENCH REPORT myaw4!mylangs MYLANGS -------------- AMERICAN GERMAN
Now assume that you attach both of these analytic workspaces while NLS_LANGUAGE and SESSION_NLS_LANGUAGE are set to American. As shown in the following code, Oracle OLAP limits mylangs in both analytic workspace to American.
REPORT myaw3!mylangsMYLANGS--------------AMERICANREPORT myaw4!mylangsMYLANGS--------------AMERICAN
