Interested to Buy Any Domain ? << Click Here >> for more details...
What are the commands youd issue to show the explain plan
for select
- 2 Answers
- 5292 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saraswathi muthuraman
SQL> explain plan for select * from dual;
Explained.
SQL> select
substr (lpad(' ', level-1) || operation || ' (' || options
|| ')',1,30 ) "Operation",
object_name
"Object"
from
plan_table
start with id = 0
connect by prior id=parent_id;
SELECT STATEMENT ()
TABLE ACCESS (FULL)
DUAL
2 rows selected.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to install oracle database 10g xe?
What are the sql clauses supported in the link property sheet ?
What is a cognitive schema?
What is a Garbage Collection? and what is full recursive Garbage collection?
How to best split csv strings in oracle 9i?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is a Sequence ?
What is the order of defining local variables and sub procedures/functions?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
What are various joins used while writing SUBQUERIES?
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
Oracle General 
