Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SYSDate, NLS_DATE_FORMAT, and default values

Re: SYSDate, NLS_DATE_FORMAT, and default values

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/12
Message-ID: <958113839.15662.0.pluto.d4ee154e@news.demon.nl>#1/1

Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com> schreef in berichtnieuws 3915f5a4.3104546_at_news.alt.net...
> On 06 May 2000 01:05:56 GMT, timkarnold_at_aol.com (TimKArnold) wrote:
>
> >Are you on 8i?
> >You may need to have DBA role.
> >
>
> OK, I logged on as SYS AS DBA via the SQL*Plus WorkSheet on NT.
>
> And ran
> --------------
> CREATE OR REPLACE TRIGGER Data_Logon_Trigger
> AFTER LOGON
> ON DATABASE
> BEGIN
> EXECUTE IMMEDIATE
> 'ALTER SESSION SET NLS_DATE_FORMAT = ''DD-MON-YYYY
> HH24:MI:SS''';
> END;
> --------------
>
> I logged on again the same way.
>
> I ran
>
> SELECT SYSDate FROM Dual;
>
> It returned
>
> SYSDATE
> ---------
> 07-MAY-00
>
> Brian

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 Received on Fri May 12 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US