PL/SQL Intro - The Dual Table

The dual table

1. dual is a table that contains single row
2. The dual table has one VARCHAR2 column named dummy
3. dual contains a single row with the value X.


The structure of the dual table:


SQL> DESCRIBE dual;
Name Null? Type
DUMMY VARCHAR2(1)


SQL> SELECT * FROM dual;

D
-
X



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!