Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg : NLS_DATE_FORMAT -

915396Mar 10 2013 — edited Mar 11 2013
Hi Experts,

I was looking into NLS_DATE_FORMAT doc here</b> and got a doubt.

When i tried changing this parameter value in v$parameter keeps the value only for that session. Starting a new session doesn't have this value. 
-- "previously : DD-MON-RR"
alter session set NLS_DATE_FORMAT = "DD-MON-RR hh24:mi:ss"
Is there any way this can persist permanently and not just session specific?

Thanks.
This post has been answered by EdStevens on Mar 10 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2013
Added on Mar 10 2013
20 comments
1,648 views