That was gr8 indeed..
thanks davey23uk for your help..

But this means i'll have to do this for all sessions. Is there any such parameter that can be toggled so that its like that through out the life of the database.

And is there any way that I can view the value of this nls_lang paramater.

Thanking you for your precious time . ..

Regards
Issac