Oracle – EBS – Database Variables

The purpose of the ALTER SESSION statement is “to specify or modify any of the conditions or parameters that affect your connection to the database. The statement stays in effect until you disconnect from the database.”
ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY';

Leave a Reply