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
query optmization techniques and quwry analyser+projects+ppts
How to get the Installed Oracle Version Information ?
How to check database size in Oracle?
How to revoke create session privilege from a user in oracle?
State the various uses of dbcc command?
What is oracle database client?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Can objects of the same schema reside in different tablespace?
What is the dynamic sql in oracle?
How to write a query with an inner join in oracle?
How to select all columns of all rows from a table in oracle?
How to add another datafile to a tablespace?
Please explain oracle left join with an example?
How to convert a string to a date in oracle database?
How to open a cursor variable?