Re: INIT.ORA Parameters

From: Michael Klimke <kli_at_lsb.de>
Date: 1998/01/21
Message-ID: <6a4hlm$qsa@ar4dec01.ar4.fra.dlh.de>#1/1

"Mark Cilia" <oracle_at_waldonet.net.mt> schreibt: > 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 Mark,

use     NLS_DATE_FORMAT = 'dd-mon-yyyy' in INIT.ORA
or      alter session set nls_date_format = 'DD-MM-YYYY:HH24.MI'; in
1. login.sql

2. $ORACLE_HOME/sqlplus/admin/glogin.sql 3. at SQL*Plus prompt

I hope it helps.
Regards Michael Received on Wed Jan 21 1998 - 00:00:00 CST