From: SPAMBLOCK.Maxwell_Smart@ThePentagon.com (Brian Tkatch)
Subject: Re: SYSDate, NLS_DATE_FORMAT, and default values
Date: 2000/05/05
Message-ID: <3912f348.2422328@news.alt.net>#1/1
References: <3911ab23.4304718@news.alt.net> <20000504193419.19941.00001279@ng-bd1.aol.com>
Organization: Altopia Corp. - Usenet Access - http://www.altopia.com
Newsgroups: comp.databases.oracle.server



>create or replace trigger data_logon_trigger 
>after logon 
>ON DATABASE 
>begin 
>    execute immediate 
>        'alter session set nls_date_format = ''yyyymmdd'' '; 
>end; 

This sounds best. Though it did not seem to work.

Is the command "ON DATABASE" or do I need to specify which database?

Also, does a specific user need to do this?

Brian