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

How to assign values to data fields in record variables?

1077


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1991


What is control file used for?

1300


What is an oracle and why it is used?

1212


What is private procedure oracle?

1048


Explain the use of ignore option in imp command.

1085


Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2146


How to rebuild an index in oracle?

1069


What are the different types of synonyms?

1197


What privilege is needed for a user to query tables in another schema?

1030


How to connect asp pages to oracle servers?

1119


How a tablespace is related to data files?

1163


20. Using a set operator, display the client number of all clients who have never placed an order.

2243


How to assign data of the deleted row to variables?

1115


What is a synonym? What are its various types?

1170