Obtaining character set informationsql select parameter

Obtaining Character Set Information
Use the NLS_DATABASE_PARAMETERS view to display the permanent NLS settings for the database, including the database and national character set. This view contains the explicitly set values, as well as the default values used by the database.

NLS parameters determine the locale-specific behavior on both the client and the server. There are four ways to specify national language support (NLS) parameters:
• As initialization parameters on the server side to specify the default server environment.

(These default settings have no effect on the client side.)
• As environment variables for the client to specify locale-dependent behavior overriding the defaults set for the server
• Using the ALTER SESSION command to override the defaults set for the client and the

•