Chapter 4 Queries
The following queries are supported:
- DUAL Table
4.1 DUAL Table
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.
In the following example, the current system date is returned.
~~~ SELECT CURRENT_DATE "date" FROM DUAL;
2013-05-14 (1 row) ~~~