Answer Posted / vaibhavi_dixit
Dual table is know as magic table, which has only one
columns with name as "DUMMY" and a row with value X.
One can describe DUAL with desc dual; command.
It is mainly used for testing some math expressions or some
character functions like
select (2+2) from dual;
It is automatically created,assigned to SYS but accessible
to all users.
VD
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
what is the difference between a web-garden and a web-farm? : Sql dba
What is difference between stored procedures and application procedures?
What is view explain with example?
How does pl sql work?
Explain the purpose of %type and %rowtype data types with the example?
Why is nosql good?
What are the advantages of normalization?
What is nosql db?
Which operator is used in query for pattern matching?
Is big data nosql?
What are sql functions? Describe the different types of sql functions?
Are there any features that are decommissioned in 11g that are not present in 11g?
How do you rank data in sql?
How do you break a loop in pl sql?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?