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
The following example shows acquiring the current date from the system:
SELECT CURRENT_DATE "date" FROM DUAL;
date
------------
2013-05-14
(1 row)