OraFAQ Forum: Client Tools » Need help to setup NLS_LANG when my PLSQL Developer executes

Home » Other » Client Tools » Need help to setup NLS_LANG when my PLSQL Developer executes (Oracle12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need help to setup NLS_LANG when my PLSQL Developer executes [message #689142]

Thu, 28 September 2023 06:57

laks_ora2023
Messages: 1
Registered: September 2023

Junior Member

Hi Team,

I need help to setting up the NLS_LANG and NLS_DATE_FORMAT parameters when my PLSQL Developer start running.

any clue if we want to run DB job or .bat file in windows.

I am using Oracle 12c and using PLSQL Developer.

Thanks in advance!

Regards,
Lakshman K

Report message to a moderator

Re: Need help to setup NLS_LANG when my PLSQL Developer executes [message #689146 is a reply to message #689142]

Thu, 28 September 2023 11:57

Barbara Boehmer
Messages: 9103
Registered: November 2002
Location: California, USA

Senior Member

I don't know about PL/SQL Developer, but in SQL*Plus you can edit the login.sql and/or glogin.sql file that runs automatically every you login and use

ALTER SESSION SET NLS_LANG =

and

ALTER SESSION SET NLS_DATE FORMAT =

to set those parameters.

For example:

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';

Report message to a moderator

Re: Need help to setup NLS_LANG when my PLSQL Developer executes [message #689147 is a reply to message #689146]

Thu, 28 September 2023 12:06

Solomon Yakobson
Messages: 3303
Registered: January 2010
Location: Connecticut, USA

Senior Member

In SQL*Developer it is Tools --> Preferences --> Database --> NLS. So I assume it is something similar in PL/SQL Developer.

SY.

[Updated on: Thu, 28 September 2023 12:08]

Report message to a moderator

Previous Topic:	problems with servers (tns:protocol adapter error)
Next Topic:	How to Generate Schema Table DDLs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 29 23:33:22 CST 2025