Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Guatemala city

    Unanswered: nls languaje in oracle9i unix

    how to change nls languaje in oracle9i unix, i need to change this parameter with SPANISH_SPAIN.US7ASCII.
    Last edited by lespana; 09-24-03 at 18:53.

  2. #2
    Join Date
    Jan 2003
    Vienna, Austria

    Re: nls languaje in oracle9i unix

    I assume you want to change the NLS-parameters at session level?

    first do
    a select * from NLS_SESSION_PARAMETERS;
    to check whic hparameters you can change at session-level.
    afterwards you can change any of theses settings using (as an example)
    alter session set NLS_DATE_FORMAT = 'DD/MM/YYYY';

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts