About

Dual is a dummy table that you can use to:

• return the value of your SQL Statement
• test a function

Data Dictionary

SELECT owner, object_id, object_type, object_name, status
From   Dba_Objects
WHERE  object_name = 'DUAL';