Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NLS_DATE_FORMAT: how to make setting persistent?
You only need to set the NLS_DATE_FORMAT='DD/MM/YYYY' on the initial file,
e,g, oracle.ini or register in Win9X.
Tim Romano ¼¶¼g©ó¤å³¹ <36EBC421.919A4B00_at_ot.com>...
>I'm a front-end application developer who has to do some DBA tasks
>now and then. While I know how to change the NLS_DATE_FORMAT in a
>session, we want to make it persistent. How does one safely
>change the INITxxxx.ORA settings so the format persists? Is there
>a text file that has to be edited? (I can see these values in TOAD
>from the View menu; can they be changed from within TOAD?) Do I
>have to bring the system down and back up again for the changes to
>stick?
>Thanks for the help.
>Tim
>
>
>
Received on Sun Mar 14 1999 - 09:13:41 CST