Types SESSIONTIMEZONE - time zone of the current session SESSIONTIMEZONE Function (and ALTER) CURRENT_DATE - current date in the time zone of the current SQL session How are dates stored in Oracle? Tony’s Tirade against TIMESTAMP WITH TIME ZONE What is the difference between varchar and varchar2? Working with Oracle Collections Using Array Objects What is the difference between varchar and varchar2? What is the difference between varchar and nvarchar? Connections How to check the maximum number of allowed connections to an Oracle database? Increasing the Number of Processes in Oracle XE. File access How to find available directory objects on Oracle 11g system? UTL_FILE Drivers Why would Oracle.ManagedDataAccess not work when Oracle.DataAccess does? SQL for Analysis and Reporting Recompilation Is recompiling Oracle Packages safe First call to a stored procedure, after successful compilation, fails. Oracle 10g Books & Manuals Database Concepts 9. Data Concurrency and Consistency 13 Read-Through, Write-Through, Write-Behind, and Refresh-Ahead Caching Oracle GoldenGate Databus