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
Can we use having without group by in sql?
How would you pass hints to the sql processor?
What is a dynamic query?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Which software is used for pl sql programming?
What is join view in sql?
How many indexes can be created on a table in sql?
how can we submit a form without a submit button? : Sql dba
How do I view a view in sql?
What is sql select statement?
How do I write a sql query in pgadmin 4?
What is package in pl sql?
Does sql support programming?
What is pl sql architecture?
what is a record in a database ? : Sql dba