Using NLS Parameter Values
Using NLS Parameter Values in the SQL Developer Environment
6-4 Oracle Database 2 Day Developer's Guide
Using NLS Parameter Values in the SQL Developer Environment
In an Oracle database, NLS parameter values are initially determined by database
initialization parameters. The DBA can set values in the initialization file, and any
changes to that file will take effect at the next database startup. Database users can
change specific parameter values for the current session (the current connection to the
database) by using a statement in the form:
See Also:
Oracle Database Reference for information about the
V$NLS_
PARAMETERS
view, which displays the NLS settings for the
current database instance
Oracle Database SQL Developer User's Guide for a discussion of SQL
Developer preferences, including NLS parameters
Oracle Database SQL Developer User's Guide for a discussion of SQL
Developer reports
Oracle Database Globalization Support Guide for a complete
discussion of globalization support with Oracle Database,
including setting up the globalization support environment
Oracle Database SQL Language Reference for information about date
and time formats
