Toad World® Forums

difference between TOAD look and sql look

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

To: toadoracle@toadworld.com

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]