Alter Session Pls Help

in your initSID.ora file set the following :

NLS_DATE_FORMAT='DD-MM-YYYY' and bounce the instance.

See Oracle 8i Reference manual chapter 1 for a list of all the initSID.ora params and what you can set.

Regards,
Norman.

PS. Alter session only changes your session - when you log out and back in again, it is no longer the same session, so the new session picks up the default date format.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------

-----Original Message-----

From: aadil_at_loveable.com (adil) [mailto:aadil_at_loveable.com] Posted At: Friday, October 12, 2001 6:01 AM Posted To: server
Conversation: Alter Session Pls Help
Subject: Alter Session Pls Help

Hi Friends,

i gave the command
alter session set NLS_DATE_FORMAT='DD-MM-YYYY';

it works properly but when i exit and again log in the session does not work how can i make the date session permanent. is it possible to put it in init.ora file.if yes pls tell me where to place it.

Thanks in advance
Adil Received on Fri Oct 12 2001 - 03:01:18 CDT