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.