Answer Posted / ramprasad.s

Hi

Indexes in oracle are to retrieve the data from the
database at a faster rate

bye
sun_ramprasad@yahoo.com

How do I learn what codesets are available in oracle?

997

---

Explain an exception?

919

---

Can select statements be used on views in oracle?

981

---

What the is the diff between local index and global index. give some example.

1587

---

What is meant by joins?

1013

---

How to use "for" statements in oracle?

1017

---

How can you merge two tables in oracle?

936

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2045

---

What is a parameter file in oracle?

1049

---

How to write text literals in oracle?

1019

---

How to create lov dynamically at runtime & attach to text field?

1097

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2077

---

How to use subqueries with the exists operator in oracle?

968

---

What is save point in oracle database?

1239

---

How to loop through a cursor variable?

1011

---