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 |
Is pl sql still used?
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
List out the acid properties and explain?
I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?
Why we use joins in sql?
Does varchar need length?
What is clause?
In a package if we have 10 procedures or functions,How to know which will execute first?
what is the command for user data type?
What is sql*loader?
How to set up sql*plus output format in oracle?
when MSQL8.0 is in market