.NET FAQs Unleashed!
 
    
    

What is the Dual table in Oracle?

Oracle databases contain a table with just one row, this is called 'Dual' table. It may be used in scenarios where in a pseudocolumn like 'User' or 'Sysdate' is being queried.
It has a column called 'Dummy' with data type of varchar2(1) ... 1 being the size.

When this table is queried, it returns a column called 'Dummy'
with a value 'X'

select * from dual;

select sysdate from dual;

SQL Queries  SQL  Create Table  DDL, Create, Alter, Drop commands  DML, Select, Insert, Update, Delete  Create Database  ACID Rules  Dual Table  NULL  Join, Inner, Outer, Left, Right, Full, Cartesian, Natural, Equi  Table, View and a Synonym?  Execute  Function  Stored Procedure  Syntax Stored Proc  Stored Procedure Vs. Function