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
What is cursor and its types?
What is embedded sql with example?
What is the primary key?
What is execute immediate?
What is data modelling in sql?
What is record variable?
What is composite data type in pl sql?
describe transaction-safe table types in mysql : sql dba
How do I view a view in sql?
what are the drivers in mysql? : Sql dba
What is a schema sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
What are the different datatypes available in PL/SQL?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Explain spool.
