The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. In Oracle, the table has a single VARCHAR2 column called DUMMY that has a value of 'X'. It is suitable for use in selecting a... Wikipedia