"Laurent Rahuel" <lrahuel.notgood_at_voila.fr> wrote in message
news:43ba54be$0$14117$8fcfb975_at_news.wanadoo.fr...
> Hi,
>
> I know how to change user's session nls_date_format with alter session,
but
> I want to alter default database nls_date_format. I tried a :
>
> alter database set nls_date_format='yyyy-mm-dd hh24:mi:ss';
>
> but I doesn't work. (ORA-02231: missing or invalid option to ALTER
DATABASE)
>
> Does anybody know how to do this ??
>
> Regards,
>
> Laurent
You need to use 'alter system set nls_date_format ..... scope = ....'.
--
Terry Dykstra
Canadian Forest Oil Ltd.
Received on Thu Jan 05 2006 - 09:45:41 CST
