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
- 5185 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 |
6. Display the client name and order date for all orders using the traditional method.
In the oracle version 9.3.0.5.0, what does each number shows?
How to fetch the row which has the max value for a column?
What are the types of Database Links ?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Point out the difference between user tables and data dictionary?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
What is instant client oracle?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
What is the meaning of recursive hints in oracle?
Difference between an implicit & an explicit cursor.?
Oracle General 
