Sunday, March 29, 2009

DUMMY!


A Thought(idea) like DUMMY on DUAL table (Oracle Database) ;)

A DUAL has one column, DUMMY, defined to be VARCHAR2(1), and contains one row with a value X.
SQL> desc dual
 
 Name                                                                    Null?    Type
 -----------------------------------------------------------------------------
 DUMMY                                                                            VARCHAR2(1)
We start a thought like "X"... 
SQL> select * from dual;

D
-
X
Anyway, We can make any thought(idea), and No limited;)

SQL> select 1 from dual;

         1
----------
         1

SQL> select sysdate from dual;

SYSDATE
---------
29-MAR-09

SQL> select 1 + 1 from dual;

       1+1
----------
         2

SQL> select 'New Idea' from dual;

'NEWIDEA
--------
New Idea

that show we have many thoughts, but start from dummy (on dual).
So, Anybody can make idea (thought), and do it.


1 comment:

Anonymous said...

Hi Surachart,

Playing with dual,take a look at Tanel's blog

http://blog.tanelpoder.com/2008/01/14/can-you-write-a-working-sql-statement-without-using-any-whitespace/

Nice One :)

Anand