Answer Posted / shivainduja

An explain plan is a representation of the access path that
is taken when a query is executed within Oracle.

SQL> explain plan for select * from emp2;

Explained.

SQL> select * from table (DBMS_XPLAN.display);

PLAN_TABLE_OUTPUT
-------------------------------------
Plan hash value: 2941272003

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

8 rows selected.

What is the usage of when clause in trigger?

1057

---

What is mutating error?

965

---

Explain the update statement in sql

992

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1080

---

Determine if oracle date is on a weekend?

1041

---

What are the limitations of sql express?

1069

---

Can we enter data in a table in design view?

969

---

What do you understand by exception handling in pl/sql?

1035

---

Can we join same table in sql?

1020

---

what are the security recommendations while using mysql? : Sql dba

1118

---

Is oracel sql developer written in java?

1105

---

Which is faster union or join?

972

---

Explain constraints in sql?

1043

---

What is sql procedures and functions?

1005

---

where are cookies actually stored on the hard disk? : Sql dba

1030

---