Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can we commit inside a function in oracle?
How can I introduce multiple conditions in like operator?
How to define an external table with a text file?
How to write a query with a right outer join in oracle?
How will you write a query to get a 5th rank student from a table student_report?
Explain overloading. Can functions be overloaded?
What is hot backup and logical backup?
What is the usage of synonyms?
What is the quickest way to fetch the data from a table?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is difference between truncate and delete?
various types of hints and their usage
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Why do we use coalesce function in oracle?
How to use "in out" parameter properly?
