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
diffe
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,
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 a
Try: Alter session set nls_date_format=;
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 trigge
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 triggers
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 and setup the date as you want it.
> Then providing any "client" does not do an
ubject: RE: 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-
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 chang
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