Changing NLS_DATE_FORMAT in glogin.sql

From: Erwan Layman <erwan_at_contact.com.sg>
Date: 1997/08/19
Message-ID: <33F90357.828BED6@contact.com.sg>#1/1

To change my Oracle session's default date format to DD-MON-YYYY, I added the following statement at the end of my glogin.sql file,

alter session set nls_date_format='DD-MON-YYYY'

However, subsequent sessions of SQL*Plus will still show my date fields as DD-MON-YY. Have I missed any steps? The same statement entered in SQL*Plus' command line works fine, but of course the formatting is lost when I exit.

I am using Oracle 7.3.2 on Unix System V R4.

Thanks in advance,
Erwan Layman

John Blackburn wrote:

> > Your suggestion to use ALTER SESSION works great. But I lose this
> > setting when I logout of SQL*Plus. How do I make this new date
format
> > setting persistent for myself and for all users of my database? I
have
> > DBA privilege. Thanks in advance.
>
> put the setting in $ORACLE_HOME/sqlplus/admin/glogin.sql
Received on Tue Aug 19 1997 - 00:00:00 CDT