Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Introduction

 

The dual Table

dual is a table that contains a single row. The dual table has one VARCHAR2 column named dummy. dual contains a single row with the value X. The structure of the dual table: SQL> SQL> DESCRIBE dual;  Name         Null?    Type  DUMMY                 VARCHAR2(1) SQL> SELECT * FROM dual; D - X SQL>