Can you explain What is DUAL table in Oracle?

ashish88

 Profile Answers by ashish88 Questions by ashish88

• Jun 11th, 2008

hello  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. sql> desc...

parthokonar

 Profile Answers by parthokonar Questions by parthokonar

• Apr 19th, 2006

Hi,Actually what happens when we issue create database command, Oracle automatically creates the tablespace and tables using the sql.bsq script found in the $oracle_home/rdbms/admin directory this scripts the dual table and is owned by the sys and has one column and one row.

Answer Question  Select Best Answer