Answer Posted / rajesh venati

this will also work.

An Explain Plan is a tool that you can use to have Oracle
explain to you how it plans on executing your query.

ex:-
SQL> set autotrace on explain
SQL> select * from emp;

Execution Plan
----------------------------------------------------------
Plan hash value: 3956160932

--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost
(%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 14 | 518 | 3
(0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| EMP | 14 | 518 | 3
(0)| 00:00:01 |
--------------------------------------------------------------------------

explain normalization concept? : Sql dba

1081

---

Why do we need pl sql?

1030

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1883

---

What is %rowtype in pl sql?

1024

---

What is index example?

1040

---

Does sqlite need a server?

1093

---

How do you create a db file?

1059

---

What is dba in sql? : SQL DBA

1084

---

How do you sort in sql?

1060

---

How do you identify a primary key?

1109

---

Explain commit, rollback and savepoint.

1049

---

How do I create a sql script?

1137

---

what is try_catch block in procedure

1802

---

What are the steps for performance tuning.

1391

---

What is offset in sql query?

1171

---