Re: SYSDate, NLS_DATE_FORMAT, and default values

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com>
Date: 2000/05/12
Message-ID: <391c0b95.1328578@news.alt.net>#1/1

>
>The trigger you created runs on startup of the database only. If you want to
>go this route you need to do this for every connect, so on schema level.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA

Hey, thanx for replying!

That works:

---

CREATE OR REPLACE TRIGGER Data_Logon_Trigger AFTER LOGON
ON SCHEMA
BEGIN
    EXECUTE IMMEDIATE
        'ALTER SESSION SET NLS_DATE_FORMAT = ''DD-MON-YYYY HH24:MI:SS''';
END;

---

A note, however. When I logon a second time in the SQL*Plus worksheet either via a command line, or via the connect dialog, it seems to reset NLS_DATE_FORMAT to just 'DD-MON-YYYY'.

However, when I start a new SQL*Plus worksheet, all is well.

Brian Received on Fri May 12 2000 - 00:00:00 CDT