Hi,
Thanks for the reply.
But as far as i tried , it is not possible to set NLS_DATE_FORMAT at instance
level (except the entry in init file.)
I think by using LOGON we won't be able to achieve setting NLS_DATE_FORMAT for
the entire instance (all the sessions) . I remember reading LOGON
Try: Alter session set nls_date_format=date_mask;
HTH
Jorma
Hi,
Thanks for the reply.
But as far as i tried , it is not possible to set
NLS_DATE_FORMAT at instance
level (except the entry in init file.)
I think
Martin Kendall wrote:
Just create a Database on-logon trigger
You can set if for the instance or even for the session. RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Wednesday, March 21, 2001 6:35 AM
Hi,
Thanks for the reply.
But as far as i tried , it is not possible to set NLS_DATE_FORMAT at
Oh yes you can. Here is the script I run as SYSTEM and it provides a common
date format for
all logins - UNLESS they override it with a SUBSEQUENT Alter Session or it
is defined in their REGISTRY
(Windows users).
Instead of ON DATABASE, you can also limit it to a particular Schema.
Otherwise,
The CREATE TRIGGER ... AFTER LOGON ON DATABASE will work on a session by
session basis. As each session logs on to the database it will execute the
trigger for that user. I currently use it in my database to do a "alter
session set current_schema=?" to that I can point different users to
Yea, to see it on a clint's SQL*Plus You have to modify
\Hkey_local_machine\software\oracle\NLS_DATE_FORMAT
At least this is on NT, I don't know about 95, 98
Gints Plivna
Just create a Database on-logon trigger and setup the date as you want it.
Then providing any "client" does not do an alter session you will have a
standard DB date format.
-Original Message-
Sent: 20 March 2001 08:36
To: Multiple recipients of list ORACLE-L
Hi Gurus,
We want to
: NLS_DATE_FORMAT not effective..help!
Just create a Database on-logon trigger and setup the date as you want it.
Then providing any "client" does not do an alter session you will have a
standard DB date format.
-Original Message-
Sent: 20 March 2001 08:36
To: Multiple