Check default NLS_DATE_FORMAT and NLS parameter in Oracle

There is a system view to check the NLS parameters.

SELECT * FROM V$NLS_PARAMETERS;

SQL> SELECT * FROM V$NLS_PARAMETERS;

PARAMETER                      VALUE
------------------------- -----------------------------
NLS_LANGUAGE              AMERICAN
NLS_TERRITORY             AMERICA
NLS_CURRENCY              $
NLS_ISO_CURRENCY          AMERICA
NLS_NUMERIC_CHARACTERS    .,
NLS_CALENDAR              GREGORIAN
NLS_DATE_FORMAT           DD-MON-YYYY HH24:MI:SS
NLS_DATE_LANGUAGE         AMERICAN
NLS_CHARACTERSET          WE8MSWIN1252
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 TZR
NLS_TIMESTAMP_TZ_FORMAT   DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY         $
NLS_NCHAR_CHARACTERSET    AL16UTF16
NLS_COMP                  BINARY
NLS_LENGTH_SEMANTICS      BYTE
NLS_NCHAR_CONV_EXCP       FALSE

these are the default parameters which is there in oracle.

if  you want to change any one of the parameter you can do changes by using alter command.

if you want to find the individual values for the specific parameter then you need to run the query by specifying the parameter.

SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_DATE_FORMAT'

like below :

ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS';
in the same way you can do for the other parameters.

if you want to save the session settings permanently you need to add the option "SCOPE=SPFILE" at the end of the command. 

Toad – SQLNET Editor && TNS Names Editor are Disabled?

After successfully Installed the toad, while trying to connect to a Database using Toad with TNS, Even the TNS entry is created in tnsnames.ora file under Oracle Home\NETWORK\ADMIN Not able to connect the due to TNS Editor and SQLNET editors are disabled.

For Toad version 11.0 above need to install the oracle client 64 bit version .

Issue 1: SQLNET Editor and TNS Names Editor Disabled as shown in below pic.

And not able to find the TNS Name in the drop down as shown in below pic

Solution : Go to environmental variables and create a new variable Name as “TNS_ADMIN” and set the value as  Oracle Home\NETWORK\ADMIN.