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
Explain overloading. Can functions be overloaded?
How to get a list of all background sessions in the database?
What is the difference between sharding and partitioning?
How to rename a tablespace in oracle?
Can group functions be mixed with non-group selection fields?
What is a static data dictionary in oracle?
what is meant by magic query
What do you mean by merge in oracle and how can we merge two tables?
How to use an explicit cursor without open statements?
What is an oracle database?
what are the advantages of running a database in archive log mode?
How to create a table index?
Explain cascading triggers.
What is a lookup table in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?