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
- 5379 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 |
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
What are cursor?where are they used?
How to change system global area (sga) in oracle?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
What are the different types of partitions in oracle?
is there a tool to trace queries, like profiler for sql server?
how to retrive xml data for using sql query?
What is oracle database client?
What are the system predefined user roles?
Is the After report trigger fired if the report execution fails ?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
How would you change old and new values in an insert, delete and update triggers?
Oracle General 
