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 |
Difference between table function and pipelined function?
What does pl sql developer do?
What is a sql profiler?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Does view contain data?
Types of optimization?
Is sql a microsoft product?
What are keys in sql?
How to run sql statements through the web interface?
Determine if oracle date is on a weekend?
What is trigger in pl sql with examples?
What is string data type in sql?