Archive for April, 2008

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 the AskTom […]

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 […]

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 […]

Check These SQL Beauties Out

Participation in the Obfuscated SQL Code Contest expired on April 1st. The SQL code that was submitted was not only obfuscated but also beautiful and artful.

When the contest started, I thought that we could just vote on the entries and select the most popular as the winner. But after seeing the entries, I believe that […]