top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: What is a dual table and why is it used?

+1 vote
Oracle: What is a dual table and why is it used?
posted Feb 12, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote
Best answer

Dual is a table that contains a dummy column with a row 'X'. it is used to satisfy the requirements of a SQL syntax containing a From clause.

answer Feb 13, 2015 by Arun Gowda
0 votes

It's a sort of dummy table with a single record used for selecting when you're not actually interested in the data, but instead want the results of some system function in a select statement:

e.g. select sysdate from dual;

The DUAL table is a special one-row table present by default in all Oracle database installations. It is suitable for use in selecting a pseudocolumn such as SYSDATE or USER

The table has a single VARCHAR2(1) column called DUMMY that has a value of "X"

You can read all about it in

answer Feb 12, 2015 by Amit Kumar Pandey