Shashank

• May 7th, 2007

 

DataType of the Column of Dual table is Varchar2(1)

Thanks,
Shashank

kowmudiswarna

 Profile Answers by kowmudiswarna Questions by kowmudiswarna

• Sep 13th, 2007

 

Hi,

The data type of column of dual table is character data type  i.e  varchar2

g_sidhu

 Profile 

• Feb 12th, 2008

 

The DUAL table is owned by the user SYS and can be accessed by all users. It contains one column, DUMMY, and one row with the value X. The DUAL table is useful when you want to return a value once only: for instance, the value of a constant, pseudocolumn, or expression that is not derived from a table with user data. The DUAL table is generally used for SELECT clause syntax completeness, because both SELECT and FROM clauses are mandatory, and several calculations do not need to select from actual

tables.