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(1) column called DUMMY that has a value of 'X'. It is suitable for use in selecting a pseudo column such as SYSDATE or USER.