Answer Posted / shankar

1.B-tree indexes:
B-tree indexes have the following subtypes:
Index-organized tables
Reverse key indexes
Descending indexes
B-tree cluster indexes
2.Bitmap and bitmap join indexes
3.Function-based indexes
4.Application domain indexes

what is the use of system.effective.date variable in oracle?

1125

---

How to use select statement to count the number of rows in oracle?

1055

---

How can we delete duplicate rows in a table?

984

---

What are the execution control statements in oracle?

1102

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2079

---

How to execute the package in oracle?

1090

---

How to use "while" statements in oracle?

1336

---

What is the usage of save points in oracle database?

972

---

Can multiple columns be used in group by in oracle?

996

---

How do we represent comments in oracle?

1059

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

2006

---

What is meant by an index?

1155

---

what are actual and formal parameters?

1114

---

What is not equal to in oracle?

1007

---

How to define a procedure inside another procedure?

1032

---