Archive for June, 2008

Give Me The Current Date Please

Did you know that in addition to SYSDATE, there is also a SQL function called CURRENT_DATE? Basically, they are the same except one important difference. SYSDATE returns the current date and time set for the operating system on which the database resides whereas CURRENT_DATE returns the current date in the session time zone. Here is [...]

Give Me The Current Date Please

Did you know that in addition to SYSDATE, there is also a SQL function called CURRENT_DATE? Basically, they are the same except one important difference. SYSDATE returns the current date and time set for the operating system on which the database resides whereas CURRENT_DATE returns the current date in the session time zone. Here is [...]

Give Me The Current Date Please

Did you know that in addition to SYSDATE, there is also a SQL function called CURRENT_DATE? Basically, they are the same except one important difference. SYSDATE returns the current date and time set for the operating system on which the database resides whereas CURRENT_DATE returns the current date in the session time zone. Here is [...]

A Quick Update

I owe you, my dear reader, a quick update. If you have been following me on Twitter, you already know that on April 23 I started a new job with a new employer. In the last three weeks, I have been adapting myself to the new environment. This is not easy to do after being [...]

Oracle Street Talk (Video)

Seems like most Australians do not know about Oracle, at least as of the date this video was shot. Of course, it depends on whom you ask the question: Have you heard of Oracle Corporation before? —Related Articles at Eddie Awad’s Blog: Oracle OpenWorld 2006 – The Arrival (Video) Oracle OpenWorld 2006 – Watch Tom [...]

AskTom Search Engine Plugin Revived

I went to AskTom to add the site’s search engine to my Firefox’s Search Bar but too bad the search engine link was broken: So, I went ahead and created a new AskTom search engine plugin. If you are browsing this page in Firefox 2 or above or IE7 or above, click here to install [...]

35+ Oracle Subdomains You May Not Know About

Here is a list of public Oracle.com subdomains that I know about. In no specific order: docs.oracle.com tahiti.oracle.com etrm.oracle.com irep.oracle.com forums.oracle.com otn.oracle.com technet.oracle.com oss.oracle.com mix.oracle.com wiki.oracle.com blogs.oracle.com asktom.oracle.com education.oracle.com crmondemand.oracle.com htmldb.oracle.com metalink.oracle.com metalink3.oracle.com academy.oracle.com partner.oracle.com my.oracle.com ilearning.oracle.com emeajobs.oracle.com campus.oracle.com jobs.oracle.com solutions.oracle.com workforce.oracle.com events.oracle.com edelivery.oracle.com sqldeveloper.oracle.com login.oracle.com st-curriculum.oracle.com ui.oracle.com exchange.oracle.com pressroom.oracle.com portalstandards.oracle.com isdportal.oracle.com download.oracle.com workforce.oracle.com elocation.oracle.com [...]

Give Me The Current Date Please

Did you know that in addition to SYSDATE, there is also a SQL function called CURRENT_DATE? Basically, they are the same except one important difference. SYSDATE returns the current date and time set for the operating system on which the database resides whereas CURRENT_DATE returns the current date in the session time zone. Here is [...]

A Quick Update

I owe you, my dear reader, a quick update. If you have been following me on Twitter, you already know that on April 23 I started a new job with a new employer. In the last three weeks, I have been adapting myself to the new environment. This is not easy to do after being [...]

Oracle Street Talk (Video)

Seems like most Australians do not know about Oracle, at least as of the date this video was shot. Of course, it depends on whom you ask the question: Have you heard of Oracle Corporation before? —Related Articles at Eddie Awad’s Blog: Oracle OpenWorld 2006 – The Arrival (Video) Oracle OpenWorld 2006 – Watch Tom [...]