SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Automatically set a TZ when you login to a database

607100Jun 11 2009 — edited Jun 11 2009

Hi,

I assume, Oracle by default will choose the same timezone as the server it is running on. Say it is BST.
But I want the timezone to be DFT.

Is there any way by which I can set the timezone automatically when any connection via unix shell script used by applications or via sql tools if done manually.
In other words, I want the alter system set time_zone=.. to be fired automatically fired when a connection to the database is made.

Rgds,
BRK

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 9 2009

Added on Jun 11 2009

3 comments

746 views