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
What is the use of file param in imp command?
How will you differentiate between varchar & varchar2?
Can a formula column be obtained through a select statement ?
What is user managed backup in Oracle?
Explain how you would restore a database using RMAN to Point in Time?
What is catalog in Oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
How to create lov dynamically at runtime & attach to text field?
What suggestions do you have to reduce the network traffic?
What are operators in oracle?
Will you be able to store pictures in the database?explain.
How to best split csv strings in oracle 9i?
Can we create database in oracle using command line ?
How do you tell what your machine name is and what is its IP address?
Is there an oracle sql query that aggregates multiple rows into one row?