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 dualName 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----------1SQL> select sysdate from dual;SYSDATE---------29-MAR-09SQL> select 1 + 1 from dual;1+1----------2SQL> 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:
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
Post a Comment