Re: SYSDate, NLS_DATE_FORMAT, and default values

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