2 Replies Latest reply on Nov 1, 2007 2:13 PM by 537661

    NLS_DATE_FORMAT change in V$NLS_PARAMETER and V$PARAMETER

    537661
      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.