Answer Posted / ankur jain

An Index is nothing, it is something like the index behind in your text book, using index we can find any topic in our text book very fast,, hence database index is also like that, oracle engine uses this index to find any particular row quickly..
This is automatically created when you create the primary key during creation of table..

How to pass parameters to procedures?

970

---

Is oracle the best database?

911

---

Is there an oracle sql query that aggregates multiple rows into one row?

930

---

How do I limit the number of oracle database connections generated by weblogic server?

1003

---

Is postgres faster than oracle?

968

---

What do you mean by merge in oracle and how can we merge two tables?

1000

---

master table and child table performances and comparisons in Oracle ?

2065

---

What exactly do quotation marks around the table name do?

915

---

What is an oracle wallet?

877

---

Can you assign multiple query result rows to a variable?

925

---

How can we find out the current date and time in oracle?

1033

---

How to filter out duplications in the returning rows using oracle?

989

---

How to use null as conditions in oracle?

999

---

What is the implicit cursor in oracle?

1035

---

What is the parameter mode that can be passed to a procedure?

978

---