Re: How to fix NLS_DATE_FORMAT setting?

Hello Keith,

"Keith Sauvant" wrote

> I want Oracle (9i) to use one NLS_DATE_FORMAT setting for all sessions
> on one database. (How) can I achieve that?
[..]
> Where can the setting be overruled using method 1)? Windows-Registry of
> Server? Windows-Registry of Client? Environment Variables? OCI8 Library
> defaults?

Client settings override the server setting. Oracle proposes to write a trigger that alters every session when logging on:
http://asktom.oracle.com/~tkyte/Misc/NLSDateFormat.html

-- 
Best Regards

Matthias Lippmann

Lippmann, Soldan und Partner 
www.lippmann-soldan.de