DUAL table is a virtual table provided by the system. Use when executing SQL where access to a base table is not required, such as when performing tests to get result expressions such as functions and operators.
Example
In the following example, the current system date is returned.
SELECT CURRENT_DATE "date" FROM DUAL;
date
------------
2013-05-14
(1 row)