Answer Posted / mahesh

For running any quey requires or generates an execution pan
before actually fetching data

in cost based approach, the oracle will generates the
execution plan based on available statistics.

oracle supports cost based approcach and it is continuously
improving fron one version to another version of oralce
database

How to use existing values in update statements using oracle?

1069

---

Respected sir, Please send me technical questions related to oracle apps..

1813

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2972

---

How to initialize variables with default values?

1249

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

---

How to define and use table alias names in oracle?

943

---

How to handle a single quote in oracle sql?

1053

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2138

---

Difference between open_form and call_form in oracle.

1163

---

State and explain about oracle instance?

1000

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2143

---

Why does for update in oracle 8 cause an ora-01002 error?

1003

---

What happens if recursive calls get out of control?

1082

---

Explain the use of file option in exp command.

1131

---

How to delete a column in an existing table in oracle?

1073

---