Answer Posted / satendra

Bit map Indexes are used with the columns having low
cardianality like Gender(M/F),Marital Status.The benefit of
it is that it requires a small space comapred to the case
if a B-Tree index is created on the same column of the
table.
Bit map Indexes are useful in the systems where data is not
getting updated frequently.

How many types of triggers are there in pl sql?

1119

---

Is sql harder than python?

1154

---

Explain aggregate functions are available there in sql?

1048

---

What is the purpose of the partition table?

1087

---

What are the topics in pl sql?

1021

---

What is package in pl sql with an examples?

1083

---

what are the differences between char and nchar? : Sql dba

1157

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1101

---

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

2315

---

what is the different between now() and current_date()? : Sql dba

1069

---

What is a trigger in sql?

1232

---

When is the update_statistics command used?

1179

---

What is index example?

1043

---

What is %type in pl sql?

1006

---

What is clause?

1224

---