Skip to Main Content
Forums

Oracle Database Discussions

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!

NLS_DATE_FORMAT change in V$NLS_PARAMETER and V$PARAMETER

537661Nov 1 2007 — edited Nov 1 2007
Hi,
I need to Change NLS_DATE_FORMAT in views like V$NLS_PARAMETER and V$PARAMETER. I have already run the command:
ALTER SYSTEM SET NLS_DATE_FORMAT = 'DD-MON-RRRR' SCOPE=SPFILE
and restarted the Database.

But still when I am querying above mentioned views, it is showing the different DATE_FORMAT not that which i need.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2007
Added on Nov 1 2007
#general-database-discussions
2 comments
2,821 views