What is magic table?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shekharjchandra
We can view the structure of the DUAL table by
SQL> DESCRIBE DUAL
or being in SYS user
SYS> SELECT DBMS_METADATA('TABLE','DUAL','SYS') FROM DUAL ;
Before that use below set command
SQL> SET PAGESIZE 100 -- or whatever you like so that you can see whole structure of the create table definition
Regards
J
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / annam.n
dual is an imaginary table.it only used for process any
functions on there, but we can't view the structure of the
dual table.so the dual table is a magic table
Is This Answer Correct ? | 6 Yes | 10 No |
Answer / brahma
They are two tables in MS Sql Server
1.Delete table
2.Update table
Is This Answer Correct ? | 3 Yes | 11 No |
What is bitemporal narrowing?
How do you remove duplicate records from a table?
What are two statement types in sql?
Why stored procedure is better than query?
What is the difference between sql and mysql?
what is user defined functions? : Sql dba
explain the difference between myisam static and myisam dynamic. : Sql dba
What is sql prepared statement?
What is bind reference and how can it be created?
Is primary key always clustered index?
How long does it take to learn pl sql?
How to start oracle sql developer?