Language-Dependent Behavior Specification

To specify how the database will act and react to language-dependent actions, it is important to have a method of control over the way the database will behave under given conditions. These behaviors are wide and varied but are controlled in three simple ways: initialization parameters, environment variables, and the ALTER SESSION command.

Initialization Parameters

There are two primary initialization parameters (each with its own subparameters) that you can use to assist you with different ways that your database will deal with different aspects of multilingual actions. These are NLS_LANGUAGE and NLS_TERRITORY.

NLS_LANGUAGE

The NLS_LANGUAGE parameter provides you with the ability to specify the way that ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.