Oracle Database Discussions

SQL> select * from dual;

D
-
X

SQL> desc dual;
Name Null? Type
----------------------------------------- -------- ----------------------------
DUMMY VARCHAR2(1)

SQL> select sysdate from dual;

SYSDATE
---------
23-OCT-09

SQL> select 'Oracle is the Information Company,Most Reliable database ' from dual;

'ORACLEISTHEINFORMATIONCOMPANY,MOSTRELIABLEDATABASE'
---------------------------------------------------------
Oracle is the Information Company,Most Reliable database

Hi techies,

1. When I do 'select sysdate from dual;' it has returned more than Five rows.
what could be the reason for this,some of the extra column also added into the DUAL table.
2. When you describing the dual table , there is column called dummy with varchar2(1).
3. when we do select sysdate from dual , which holds current date more the 1 byte (see example).
and the second example It also holds the one big sentence, even the dummy column is varchar2(1).

Sorry if I am wrong anywhere by this question.

Thanks,
Tippu