Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYSDate, NLS_DATE_FORMAT, and default values
Are you on 8i?
You may need to have DBA role.
Tim
>>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?
>
>
Received on Sat May 06 2000 - 00:00:00 CDT