But what about registry in unix platform.
-----Original Message-----
From: "Obregón, Francis" [mailto:oracledba-ezmlmshield-x38984439.[Email address protected]
Sent: 30 November 2004 20:33
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
DISCLAIMER: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee/recipient. Access to this message by any one else is unauthorized. If you are not the intended addressee/recipient any disclosure, copying or distribution of the message, or any action or omission taken by you by relying on it is prohibited and may be unlawful. Please notify the addressor/sender immediately if you have received this message in error. The organization is not responsible for any damage caused by a virus or an alteration of the e-mail by a third party or otherwise. The contents of this message may not necessarily represent the views or the policies of the organization.
Oracle LazyDBA home page