Why DUAL table is not visible?

Editorial / Best Answer

krishnaindia2007  

  • Member Since Sep-2007 | May 13th, 2008


DUAL is a part data dictionary and owned by SYS. You should not make modifications to this   table. 
It contains only one row and  one column of VARCHAR2 datatype.
Used to refer an object which does not have any pysical reference in database table.
Ex:- Select sysdate from dual.

Showing Answers 1 - 2 of 2 Answers

jhoombrabar

  • Aug 16th, 2007
 

Because its a dummy table.

DUAL is a part data dictionary and owned by SYS. You should not make modifications to this   table. 
It contains only one row and  one column of VARCHAR2 datatype.
Used to refer an object which does not have any pysical reference in database table.
Ex:- Select sysdate from dual.

Aditya Kumar

  • Dec 16th, 2017
 

If it contains only one column with varchar2 data type then how can it return a date through sysdate.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions