Pages

Showing posts with label Oracle DUAL table. Show all posts
Showing posts with label Oracle DUAL table. Show all posts

What is DUAL table for?

DUAL is dummy table with 1 column (DUMMY - varchar2(1) - nullable) and 1 row 'X'

Test below queries to see details.

SELECT * FROM DUAL

DESCRIBE DUAL