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 the use of file param in imp command?

1112


How will you differentiate between varchar & varchar2?

990


Can a formula column be obtained through a select statement ?

2262


What is user managed backup in Oracle?

1073


Explain how you would restore a database using RMAN to Point in Time?

2093


What is catalog in Oracle?

1262


11. Display the client number and name and the client number and name of the person who referred that client.

2270


How to create lov dynamically at runtime & attach to text field?

1096


What suggestions do you have to reduce the network traffic?

894


What are operators in oracle?

1008


Will you be able to store pictures in the database?explain.

924


How to best split csv strings in oracle 9i?

983


Can we create database in oracle using command line ?

1024


How do you tell what your machine name is and what is its IP address?

2001


Is there an oracle sql query that aggregates multiple rows into one row?

930