NLS language

[Jani]

Could I use any other language on session level ,
like ......... URDU...........Arabic........ , tell me about parameters to set use different language on SQL prompt and retrieve data in same set language ?
Thanx

[Shestakov]

You can use different languages in one session

connect usr/pwd@db
...
alter session set nls_language = 'LLLLL';
...

alter session set nls_language = 'NEW LLLLL';

...
disconnect;