Wednesday, November 30, 2005

Oracle is Insane

Oracle has a built in table that always has one row.
The table is called DUAL.

This is how you can call functions in a sql call, such as:
SELECT SYSDATE + 99 FROM DUAL

SQL Server lets you call functions explicitly such as:
SELECT GetDate()

Oracle is clearly insane.

Posted by chriseyre2000 in 15:21:13
Comments

Leave a Reply