Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: nls_date_format - How do I change it on NT installation of Oracle.
Hi,
In NT registry you can add this parameter (NLS_DATE_FORMAT) in
hkey_local_machine->software->oracle or
hkey_local_machine->software->oracle->yourOracleHome.
If you want change this parameter only for current session you can use
alter session set nls_date_format = 'your format';
Yours Iurie.
TV Guide, CA, Oracle DBA.
New User wrote in message <838ff4$e8s1_at_news1.keane.com>...
>I want to change the NLS_DATE_FORMAT.
>
>I have already changed the init.ora and initSID.ora files. But I came to
>know that I need to change the Registry values also. How do I do that? I
>want to know the exact key that I need to add to the Registry to effect the
>change.
>
>Thanks in advance.
>
>
Received on Wed Dec 15 1999 - 11:56:23 CST