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 a quick [...]

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

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

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 Kyte (video)
I don’t [...]

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
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
usableapps.oracle.com
marvel.oracle.com
apex.oracle.com
store.oracle.com
otnsemanticweb.oracle.com
search.oracle.com

Do you know an Oracle.com subdomain that is not listed above? Feel free to share it with us.
Update: Thanks to Colin for letting us know about this query which gives us more [...]

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

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 Kyte (video)
I don’t [...]