How about glogin.sql?

> Or you can issue an ALTER SESSIO SET NLS_DATE_FORMAT command or better yet, define an environment
> variable NLS_DATE_FORMAT with the current format you want. Whenever you log into SQL*Plus it sets
> NLS_DATE_FOMAT to the value specified in the string for your environment variable. Works on unix
> as well as Windows....
>
>
> - Morten Grimnes :-)
>
> -----Original Message-----
> From: "Obregón, Francis" [mailto:oracledba-ezmlmshield-x38984439.[Email address protected]
> Sent: 30. november 2004 16:03
> To: LazyDBA Discussion
> Subject: RE: NLS_DATE_FORMAT
>
> I know that you can put the NLS_DATE_FORMAT in the registry in the entry
> that have the ORACLE_HOME.
>
> -----Original Message-----
> From: Declan Heerey
> [mailto:oracledba-ezmlmshield-x50028630.[Email address protected]
> Sent: martes, 30 de noviembre de 2004 7:12
> To: LazyDBA Discussion
> Subject: RE: NLS_DATE_FORMAT
>
> I don't think you can set NLS_DATE_FORMAT for the system dynamically. As far
> as i know you set it in the init.ora and have to bounce the database for it
> to be set.
>
> Anyone else know any better?
>
> -----Original Message-----
> From: Rupesh Shah
> [mailto:oracledba-ezmlmshield-x71416616.[Email address protected]
> Sent: 30 November 2004 13:00
> To: LazyDBA Discussion
> Subject: NLS_DATE_FORMAT
>
>
> How to change nls date format for the database.?
>
>
>
> Below command does not work
>
> alter system set NLS_DATE_FORMAT = 'MM/DD/YYYY';
>
>
>
> Regards,
>
> rupesh
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> _____________________________________________________________________
> This e-mail has been scanned for viruses by MCI's Internet Managed Scanning
> Services - powered by MessageLabs. For further information visit
> http://www.mci.com
>
> _____________________________________________________________________
> This e-mail has been scanned for viruses by MCI's Internet Managed Scanning
> Services - powered by MessageLabs. For further information visit
> http://www.mci.com
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> ---AVISO LEGAL---
> Este mensaje y cualquier archivo transmitido con él está dirigido únicamente
> a su destinatario. Se informa a quien lo reciba por error o lo obtenga sin
> ser su destinatario, que la información contenida en él es confidencial y su
> uso no autorizado. Si usted no es el destinatario debe abstenerse de
> reproducir, enviar o entregar el mensaje o sus archivos a otra persona, y
> debe borrarlo de manera inmediata. Cualquier uso ilegítimo de este mensaje
> está sujeto a sanciones penales y administrativas.
> Para información y consultas visite nuestro sitio web: http://www.bcn.gob.ni
> --- IMPORTANT NOTICE ---
> This message and any file attached thereto is for the intended recipient
> only. If you have received this e-mail in error or had access to it, you
> should note that the information in it is confidential and any use thereof
> is unauthorized. Any reproduction and any transmission or dissemination
> thereof to other persons is prohibited. It should be deleted immediately
> from your system. Any unlawful use of this message will result in criminal
> and administrative prosecution.
> For additional information, please visit our website : http://www.bcn.gob.ni
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>
> **********************************************************************
> This footnote confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
> Questions can be forwarded to [Email address protected]
> **********************************************************************
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>


--
Todd Pepling, Oracle DBA
420 Vineyard Dr.
Gibsonia, PA 15044
email: [Email address protected]
home: 724-444-6403
cell: 412-779-1597


Oracle LazyDBA home page