Re: Changing NLS_DATE_FORMAT in glogin.sql

Erwan Layman wrote:
>
> 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:
>

Hello!
I found this on my Windows NT clients - I think there should be similarities:
There are several login.sql and glogin.sql spread over my installation. One is located in \orant\plus32, another is located in \orant\dbs and so on. I normally use to place a
statement like

set serveroutput on
begin
  dbms_output.enable( 20000);
  dbms_output.put_line( '... running %ORACLE_HOME%\DBS\LOGIN.SQL'); end;
/

into my glogin.sql and login.sql files to distinguish.

hope this helps. greetings from sunny AUSTRIA.

franz.lindsberger_at_siemens.at Received on Fri Aug 22 1997 - 00:00:00 CDT