Re: INIT.ORA Parameters

In article <34c5ba38.0_at_mail>,
  "Mark Cilia" <oracle_at_waldonet.net.mt> wrote:
>
> Hi
>
> What INIT.ORA parameters do I have to change so that when I execute the
> command select (sysdate) from dual, I will get the date in dd-mon-yyyy
> format
>
> Regards

Hi,

You can set date in the init.ora file using the parameter nls_date_format. However it can be dangerous because your existing application which are manipulating date format may not work properly. It is better to change the date format in the session or at the application level.

Bye
Ajit Singh
Sr. System & DBA

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet