Re: Alter Session Pls Help

adil wrote:
>
> Hi Friends,
>
> i gave the command
> alter session set NLS_DATE_FORMAT='DD-MM-YYYY';
>
> it works properly but when i exit and again log in
> the session does not work how can i make the date session permanent.
> is it possible to put it in init.ora file.if yes pls tell me where to place it.
>
> Thanks in advance
> Adil

It does not work because after you log out, the session is terminated.

To make this permanent, it will need to be in your environment.

Win: Set the parameter in the registry. For the exact method of doing this, see the docs.
UNIX: Korn and bash shells - export NLS_DATE_FORMAT="DD-MM-YYYY"; for other shelss, see your docs.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.