(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 Dimension Status"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 4-9, "Changing NLS_LANGUAGE" and Example 5-102, "Changing NLS_LANGUAGE Without Changing the Language of the OLAP Session".
Example 5-96 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!mylangs MYLANGS -------------- AMERICAN REPORT myaw4!mylangs MYLANGS -------------- AMERICAN