dual table

dual table has one VARCHAR2 column named dummy and contains a single row with the value X. DESCRIBE command shows the structure of the dual table:


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

SQL>
SQL> SELECT * FROM dual;

D
-
X

SQL>
Home »
Oracle »
Select » 

Where:
  1. Where clause
  2. dual table
  3. Comparison Operators
  4. ANY
  5. ALL
  6. LIKE, NOT LIKE
  7. IN, NOT IN
  8. Between...AND, NOT Between...AND
  9. IS NULL, IS NOT NULL
  10. Logical operator AND, OR, NOT
  11. Operator Precedence for AND, OR, NOT
Related: