how set nls parameters

[Ken Anderson]

What is the best way to set session nls parameters that will override db nls parameters so that they are always set when I open a new plsql developer session?

Thanks,
-Ken

 

[Marco Kalter]

You can use the Oracle Registry for this, so that all your Oracle related tools will use these settings, or you can enter "alter session" commands in the AfterConnect.sql file in the PL/SQL Developer installation directory. For example:

alter session set nls_date_format='dd-mm-yyyy';
alter session set nls_territory='sweden';
alter session set nls_language='swedish';