sessiontimezone, current_timestamp : Session variable « SQL Plus « Oracle PL / SQL

Oracle PL / SQL 1.  Aggregate Functions 2.  Analytical Functions 3.  Char Functions 4.  Constraints 5.  Conversion Functions 6.  Cursor 7.  Data Type 8.  Date Timezone 9.  Hierarchical Query 10.  Index 11.  Insert Delete Update 12.  Large Objects 13.  Numeric Math Functions 14.  Object Oriented Database 15.  PL SQL 16.  Regular Expressions 17.  Report Column Page 18.  Result Set 19.  Select Query 20.  Sequence 21.  SQL Plus 22.  Stored Procedure Function 23.  Subquery 24.  System Packages 25.  System Tables Views 26.  Table 27.  Table Joins 28.  Trigger 29.  User Previliege 30.  View 31.  XML Java Java Tutorial Java Source Code / Java Documentation Java Open Source Jar File Download Java Articles Java Products Java by API C# / C Sharp C# / CSharp Tutorial ASP.Net JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial PHP Python SQL Server / T-SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Oracle PL / SQL » SQL Plus » Session variable   sessiontimezone, current_timestamp   SQL> SQL>  column sessiontimezone for a15 SQL>  col current_timestamp format a36 SQL> SQL>  select sessiontimezone, current_timestamp   2      from dual; SESSIONTIMEZONE CURRENT_TIMESTAMP --------------- ------------------------------------ -08:00          16-JUN-08 04.26.31.666000 PM -08:00 1 row selected. SQL> SQL>  alter session set time_zone = '-11:00'; Session altered. SQL> SQL>  select sessiontimezone, current_timestamp(3) current_timestamp from dual; SESSIONTIMEZONE CURRENT_TIMESTAMP --------------- ------------------------------------ -11:00          16-JUN-08 01.26.31.806 PM -11:00 1 row selected. SQL> SQL> --   Related examples in the same category 1.  alter the session with the ALTER SESSION statement and set the session's time zone forward 2.  alter session set nls_date_format = 'dd-MON-yyyy hh24:mi:ss'; 3.  alter session set OPTIMIZER_MODE = RULE 4.  Adjust your session time zone to -08:00, display the contents of your time table. 5.  alter session set cursor_sharing = force 6.  alter session set use_stored_outlines 7.  Event-based call and exception tracing 8.  event-based call and exception tracing. 9.  SQL trace 10.  uses dynamic SQL to issue an ALTER SESSION statement. 11.  ALTER SESSION SET QUERY_REWRITE_ENABLED 12.  alter session set sql_trace=true 13.  sql_trace a stored procedure 14.  Set the following session parameters to enable query rewrite: 15.  If your session time zone is not US/Central (-06:00), alter your session to Central time: 16.  alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS' 17.  Alter time_zone 18.  demonstrates the use of DBMS_SQL to execute an ALTER SESSION statement. 19.  interaction between ALTER SESSION and autonomous transactions.

w___ww_._ja___v__a__2s__.c__o___m___ | Contact Us

Copyright 2003 - 08 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.