title: How can I get Time Zone Region from SQLPLUS?
body: <p>I am using Oracle Developer and Oracle 11g (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production)</p>
  
  <pre><code>select SESSIONTIMEZONE from DUAL;
  </code></pre>
  
  <p>Result in SQLPLUS/system_config_tbl_load.sql:  -4:00<br>
   Result in SQL Developer:                       America/New_York </p>
  
  <p>gives different results in SQL Developer and SQLPLUS.<br>
  I want to see the region in SQLPLUS.      </p>
  
  <p>Additionally I have to do this for multiple locations and do not have the option of changing the Time Zone using "ALTER SESSION SET time_zone = 'America/New_York'"</p>