Re: nls_date_format

"Wayne Pascoe" <wayne.pascoe_at_realtime.co.uk> a écrit dans le message news: m11yqi5wyk.fsf_at_zaphod.realtime.co.uk...
> Hi all,
>
> Is there any way to change the default oracle nsl_date_format after
> I've created a database? I am having to issue
>
> alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';
>
> at the beginning of each of my sessions. Is there a way to make this
> the default, or do I have to recreate the database?
>
> Thanks,
>
> --
> - Wayne Pascoe
> E-mail: wayne.pascoe_at_realtime.co.uk
> Phone : +44 (0) 20 7544 4668
> Mobile: +44 (0) 788 431 1675

You can put it in your init.ora file. This value becomes the default for all clients that don't override it with an environment variable such as nls_lang.

--
Regards
Michel