Change NLS_DATE_FORMATE of Database......?? [message #313620] |
Sun, 13 April 2008 23:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Manoj.Gupta.91
Messages: 239 Registered: March 2008 Location: Delhi
|
Senior Member |
|
|
Hi All,
I want to change my default date format for database. i.e. NLS_DATE_FORMAT
default is DD-MON-YYYY
I want DD/MM/YYYY
for a single session I can do this with
ALTER SESSION SET NLS_DATE_FORMAT= 'DD/MM/YYYY' ;
but I want to do it for all the sessions of database.
I searched my init.ora file there is no such parameter specified.
Do I need to add this parameter in this file.........??
OR is there any other initialization file in Oracle Database 10g..?
Thanks & Regards
Manoj
|
|
|
|
|
|
|