Answer / rm thirunavukkarasu

Index is used to Retrive the Information in efficient
manner. And query processor perform reliably.

There are 3 types of Index namely
*Cluster based Index
*Non Cluster based Index
*Noncomposite Index
*Compositive Index
*Unique Index

For more info adt sql plz visit www.thiruna.blog.com

Answer / sandip kumar chaturvedi

index is a data structure that improve the operation on
table.there are two types of index.
1) ordered index.
2) hashed index.
up to 249 clustered indexes per table.

How to load data with sql*loader?

1 Answers  

---

What is minus?

1 Answers  

---

Does sql use python?

1 Answers  

---

What do you mean by “trigger” in sql?

1 Answers  

---

What is sql integrity?

1 Answers  

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

1 Answers   TCS,

---

What are the advantages of the packages

6 Answers   Oracle,

---

Why use triggers in sql?

1 Answers  

---

Store procedure will return a value?

4 Answers   eMids,

---

How do you concatenate in sql?

1 Answers  

---

Can you alter start with clause?

1 Answers   TCS,

---

How do you go back in sql?

1 Answers  

---