Assuming I only have access to SQL*Plus, how would I see what values the
NLS_NUMERIC_CHARACTERS is set at for: 1) a particular database, 2) a
particular session ?

How do I alter there parameters for the base as a whole and for a session?

Thanks

J.

To see you current NLS parameter values issue the following SQL:

select * from nls_session_parameters;


To change a parameter at the session level is the

ALTER SESSION SET NLS_NUMERIC_CHARATERS= '??';


command.

"UNIXNewBie" <nospan (AT) nospam (DOT) com> wrote