DUAL

DUAL is a system table and has one column called DUMMY and one row containing the value X. The DUAL table is a convenience tool that enables users, or their programs, to select a single known constant or function.

For example, since DUAL contains only a single column, it makes the following types of commands more sensible:

SELECT USER()FROM DUAL;
SELECT NOW()FROM DUAL;
SELECT DATABASE()FROM DUAL;

...and for other functions where you want only a single value returned.

If you would like to provide a slightly different format of the data in the information_schema, you can modify the queries to return the name of the configuration file. In the file %GENESIS_HOME%\bin\cview.sql, modify the following lines:

These changes will cause the configuration file of the current database to be printed on each line.