how many types of index?

2 Answers   Cap Gemini, TCS,

---

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  

---

What is ordinary table in oracle?

0 Answers   MCN Solutions,

---

Please explain oracle data types with examples?

0 Answers  

---

how may join possible between (requisition with purchase order)

0 Answers  

---

What are the various oracle database objects?

0 Answers  

---

How to get the Installed Oracle Version Information ?

0 Answers   MCN Solutions,

---

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

---

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers   Value Labs,

---

24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.

2 Answers   Wipro,

---

What is the data type of dual table?

0 Answers  

---

Do you know about aggregate functions? What is row num function? Can it be used all databases?

1 Answers   Bravura Solutions, Cap Gemini,

---