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 |
--------------------------------------------------------------------------

What are few of the schema objects that are created using PL/SQL?

1030

---

how to create a table index in mysql? : Sql dba

1059

---

Advantages and disadvantages of stored procedure?

1120

---

What is an exception in PL/SQL? What are the two types of exceptions?

1309

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1698

---

what is the bond code in materialized view?

3000

---

How do you add a column to a table?

1050

---

Which language is used in sql?

1052

---

Define implicit and explicit cursors.

1143

---

What is tuple in sql?

1070

---

How do I restart sql?

965

---

Can there be 2 primary keys in a table?

994

---

Can instead of triggers be used to fire once for each statement on a view?

962

---

How do I view a sql database?

1018

---

What operating systems are supported by oracle sql developer?

953

---