ALTER SESSION 1

[jbpelletier]

hi,

our server use this date format : DD-MON-RR

and i whant to use this statement at the begining of a pl/sql script to change the date format .. but only for that script...

>> alter session set nls_date_format='DD-MM-RR';

will other user (doing other thing on that oracle server) be affect by this statement or only "me"..?

once the script is done my "sesion" end (i use a disconect and quit statement)

do i need to re-alter again with DD-MON-RR before quiting?

tanx
jb

 

[SantaMufasa]

JB,

As the command implies, "ALTER SESSION...", it affects only your session. Even if you have other sessions in other Windows, your ALTER command does not affect them. The duration of the ALTER SESSION command is just during the life of that session. So, when you disconnect, your next log-in will reflect the original date settings.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 19:59 (22Dec04) UTC (aka "GMT" and "Zulu"),
@ 12:59 (22Dec04) Mountain Time

 

[jbpelletier]

tanx,

that's what i was thinking.. couldn't find the info "quickly" on google :/

jb