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

DUAL System Table Description

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.

Example

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