Answer Posted / padiya hiten

select * from emp e1 where (3=(select count(distinct
(e2.sal))from emp e2 where e2.sal>=e1.sal));

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?

1949

---

What are the different types of record groups in oracle? Explain each of them

1025

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1020

---

Where do we use decode and case statements?

1011

---

What is difference between sid and service name in oracle?

956

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2258

---

Which are the five query types available in oracle?

949

---

How to calculate date and time differences in oracle?

1041

---

Explain drop constraint oracle?

1067

---

What is a server parameter file in oracle?

1055

---

What is the data pump export utility?

1081

---

How to get a list of all background sessions in the database?

993

---

How to convert characters to numbers in oracle?

1065

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2025

---

How to display row numbers with the records?

1075

---