Oracle Database - DUAL

> Database > Oracle Database

Table of Contents

1 - About

Dual is a dummy table that you can use to:

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

2 - Data Dictionary

SELECT owner, object_id, object_type, object_name, STATUS
FROM   Dba_Objects
WHERE  object_name = 'DUAL';