A couple of nice-to-know queries:
SELECT SESSIONTIMEZONE FROM DUAL;
returns the time zone of the client session.
SELECT DBTIMEZONE FROM DUAL;
returns the time zone of the database server.
Possibly related:
- Back to basics: Equi and non-equijoins
- What is the COST?
- Northwest Oracle Users Group (NWOUG) 2006 Fall Conference
- Oracle’s grumpy old men
- Cool Undocumented OVERLAPS Predicate
Tagged | Post a Comment


















Home > About This Post
This entry was posted by Eddie Awad on Thursday, June 30th, 2005, at 3:22 pm, and was filed in Oracle, Tips.
Subscribe to the
RSS 2.0 feed for all comments to this post.
Post a Comment