Execute sql query determine your session-level nls settings

1060 Chapter 20 ✦ Study Guide

NLS_LANGUAGE=FRENCH
NLS_TERRITORY=CANADA

2. Connect to the CERTDB instance using SQL*Plus or Server Manager Line

PARAMETER VALUE
------------------------- -------------------------NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8ISO8859P1
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM

PARAMETER VALUE
------------------------- -------------------------NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM

Chapter 20 ✦ Study Guide 1061

4. Execute the following query and note its results:

SELECT SYSDATE FROM DUAL;

1. Connect to the CERTDB instance as user Student with a password of Oracle.

2. Execute a SQL query to determine your session-level NLS settings. Are they