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 varray?
how the indexes are stored in the Oracle Database?
Is insert autocommit in oracle?
What is a dead lock in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
How can I introduce multiple conditions in like operator?
How many memory layers are in the oracle shared pool?
What do you mean by cdb and pdb in oracle 12c?
How to call a sub procedure?
How to use group functions in the select clause using oracle?
What is an oracle and why it is used?
What is ASM (Automatic Storage Management) in Oracle?
Who developed oracle & when?
What are the oracle built-in data types?
Explain parameter file in oracle.