Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain the concept of the DUAL table.

Answer Posted / eshwari

Dual table is a sample permanent table which come along with
oracle.
for example if u want to knw the sin(45) value then u have
to retreave it from a table.but there is no table to
retreave that value.
so we use the sample table dual as table name in place of
table name in the select query.

ex:select sin(45) from dual;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rich query?

983


How to speed up webrick?

1077


How do I uninstall oracle 11g?

1122


What is bulk load in oracle?

1072


what is normalisation?what are its uses?

2274


How to use "startup" command to start default instance?

1038


How to display employee records who gets more salary than the average salary in the department?

1068


Is oracle a relational database?

920


Explain what are synonyms used for?

1038


does the query needs a hint to access a materialized view?

1860


What is the usage of analyze command in oracle?

1095


How many types of tables supported by oracle?

1079


What is a cursor in oracle?

1177


What do you mean by a database transaction & what all tcl statements are available in oracle?

994


Why do we use bulk collect in oracle?

1059