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
- 5380 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 |
sql query to get zero records from a table
What is the use of oracle?
Will you be able to store pictures in the database?explain.
What is the simplest tool to run commands on oracle servers?
How to sort the query output in oracle?
Can a parameter be passed to a cursor?
What is meant by an index?
What is different types of joins?
What is format trigger?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to add a new column to an existing table in oracle?
Explain database link?
Oracle General 
