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 are field types?
What are the disadvantages of file system?
How to use boolean type in select statement?
Mention what are different methods to trace the pl/sql code?
What is sql and also describe types of sql statements?
What view means?
What are the benefits of pl sql?
how would concatenate strings in mysql? : Sql dba
Which is better join or subquery?
what is the difference between sql and t-sql? : Transact sql
How long does it take to learn pl sql?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Explain mutating table error.
When can we use the where clause and the having clause?
Can ddl statements be used in pl/sql?