Answer / aswini

select distinct client_number from <table_name>;

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

0 Answers   Oracle,

---

what is the syntax of ALTER command?

8 Answers  

---

Can multiple columns be used in group by in oracle?

0 Answers  

---

material view and view disadvantages?

0 Answers  

---

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

5 Answers   Microsoft, Oracle, TCS,

---

---

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

---

How to grant create session privilege to a user in oracle?

0 Answers  

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

0 Answers   ESS,

---

What is a select query statement in oracle?

0 Answers  

---

Explain the function of optimizer in oracle?

0 Answers  

---

13. Display the second to fifth characters in each client name.

2 Answers   Wipro,

---

What language does oracle use?

0 Answers  

---