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
How to assign values to data fields in record variables?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is control file used for?
What is an oracle and why it is used?
What is private procedure oracle?
Explain the use of ignore option in imp command.
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How to rebuild an index in oracle?
What are the different types of synonyms?
What privilege is needed for a user to query tables in another schema?
How to connect asp pages to oracle servers?
How a tablespace is related to data files?
20. Using a set operator, display the client number of all clients who have never placed an order.
How to assign data of the deleted row to variables?
What is a synonym? What are its various types?