You are here: Reference Information > SQL Reference Information > SQL System Tables > DUAL System Table Description

DUAL System Table Description


The SQL standard requires that any query that is made must be from a table. DUAL is a helpful pseudo table that allows you to query expressions that don't require data from a table.


SELECT now() FROM dual;
 2014-10-14 10:23:12.967569
SELECT 52*5 FROM dual;