svsraju81

 Profile Answers by svsraju81 

• Jul 24th, 2008

 

Dual table is a temporary table, it contains a single row and single column. If we return a data from dual table it gives a single row.

nikhilsaxena

 Profile Answers by nikhilsaxena Questions by nikhilsaxena

• Aug 10th, 2008

 

It has single row and single column.

sat_orcl

 Profile Answers by sat_orcl 

• Aug 29th, 2008

 

Dual table is dummy table and it is having only one column with varchar2 datatype

me.ranjeet

 Profile Answers by me.ranjeet 

• Sep 24th, 2008

 

dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. rene@ora92> desc dual Name Null? Type ----------------------- -------- ---------------- DUMMY VARCHAR2(1)rene@ora92> select * from dual;D-XThe owner of dual is SYS but dual can be accessed by every user. As dual contains exactly one row (unless someone fiddled with it), it is guaranteed to return exactly one row in select statements. Therefor, dual is the prefered table to select a pseudo column (such as sysdate select sysdate from dualAlthough it is possible to delete the one record, or insert additional records, one really should not do that!.

malapati

 Profile Answers by malapati 

• Oct 8th, 2008

 

Every database contains only one dual table that is also called as dummy table

dual is used to evaluate expressions
 
example:select 3+4+6 from dual;  or select sysdate from dual

d_pranjal

 Profile Answers by d_pranjal 

• Sep 5th, 2010

 

Dual table is owned by SYS. Data dictionary come under SYS, dual is part of data dictionary. Dual table consist only one row and only one column containing value x

sudipta kumar dhal

• Sep 5th, 2011

 

Dual table is called a dummy table because it is not meant for storing any useful data.