dual table

dual table has one VARCHAR2 column named dummy and contains a single row with the value X.DESCRIBE command shows the structure of the dual table:

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

SQL>
SQL> SELECT * FROM dual;

D
-
X

SQL>