Interested to Buy Any Domain ? << Click Here >> for more details...
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
How does one load ebcdic data? : aql loader
what is difference between delete and truncate commands? : Sql dba
What is trigger point?
What is scope of pl sql developer in future?
explain the difference between myisam static and myisam dynamic. : Sql dba
How to process query result in pl/sql?
Can procedure in package be overloaded?
Why select is used in sql?
What are the sql commands?
Explain the methods used to protect source code of pl/sql.
How do I truncate a sql log file?
What are few of the schema objects that are created using PL/SQL?
Can there be more than one function with a similar name in a pl/sql block?
what is subquery? : Sql dba
How many types of normalization are there?
