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
- 5288 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 |
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Write a syntax for update query in oracle?
How to create a server parameter file?
How to convert characters to times in oracle?
How to lock and unlock a user account in oracle?
What is a Segment ?
List out the components of logical database structure of oracle database.
When do I need to use a semicolon vs a slash in oracle sql?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
Explain about the analyze command in oracle?
What is the difference between a user and a schema in oracle?
how to select second mauximum value in a given table under salary column
Oracle General 
