Hi,
Starting TOAD 12.1.1.1 and connecting to a database, go to tab Database, Administer, NLS params and the the tab Database where the NLS params is showing, i get a different look then i directly connect on unix through SQLPLUS and ask the params for NLS_.
In Toad i got everything in AMERICAN, AMERICAN and in SQLPLUS DUTCH the Netherlands.
By example, NLS language is showing in toad AMERICAN and in sqlplus show parameter NLS_; i got DUTCH.
What’s wrong here…
Gr. Jan
I would run a script like this to ensure you’re checking params against params (Instance vs. DB vs. Session)
column
“Sesssion”
format a30
column
“Instance”
format a30
column
“Database”
format a30
set
linesize 300
select
ndp.parameter
,
trim(max(nsp.value))
“Sesssion”
,
trim(max(nip.value))
“Instance”
,
trim(max(ndp.value))
“Database”
FROM
nls_session_parameters nsp
,
nls_instance_parameters nip
,
nls_database_parameters ndp
WHERE
ndp.parameter = nsp.parameter (+)
AND
ndp.parameter = nip.parameter (+)group
by ndp.parameter
;
From: j.dekker [mailto:bounce-jdekker@toadworld.com]
Sent: Thursday, October 15, 2015 9:36 AM
Subject: [Toad for Oracle - Discussion Forum] difference between TOAD look and sql look
difference between TOAD look and sql look
Thread created by j.dekker
Hi,
Starting TOAD 12.1.1.1 and connecting to a database, go to tab Database, Administer, NLS params and the the tab Database where the NLS params is showing, i get a different look then i directly connect on unix through SQLPLUS and ask the params for NLS_.
In Toad i got everything in AMERICAN, AMERICAN and in SQLPLUS DUTCH the Netherlands.
By example, NLS language is showing in toad AMERICAN and in sqlplus show parameter NLS_; i got DUTCH.
What’s wrong here…
Gr. Jan
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Afternoon All,
On 15/10/15 14:28, j.dekker wrote:
In Toad i got everything in AMERICAN, AMERICAN and in SQLPLUS DUTCH the
Netherlands.
By example, NLS language is showing in toad AMERICAN and in sqlplus show
parameter NLS_; i got DUTCH.
What's wrong here...
Nothing! Toad gives you a lot more information that SQL*Plus does. There
are three different sets of parameters:
Session - from NLS_SESSION_PARAMETERS
Instance - from NLS_INSTANCE_PARAMETERS
Database - from NLS_DATABASE_PARAMETERS
I suspect that SQL*Plus is giving you the NLS_SESSION_PARAMETERS. When
you see the parameter grids in Toad, click on the "session" tab to see
which ones are current in your session - mine shows AMERICAN, AMERICA
and so on in Database and Instance, but in Session I have English,
United Kingdom.
HTH
--
Cheers,
Norm. [TeamT]