How to create an oracle database manually?

0 Answers  

---

Query to get max and second max in oracle in one query ?

34 Answers   CTS, Keane India Ltd, TCS, Wipro,

---

What are the sql clauses supported in the link property sheet ?

1 Answers   Oracle,

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

0 Answers  

---

How does one get the view definition of fixed views/tables?

0 Answers  

---

What is Library Cache in Oracle?

0 Answers   MCN Solutions,

---

What are the differences between blob and clob in oracle?

0 Answers  

---

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,

---

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

---

How to drop an index in oracle?

0 Answers  

---

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

5 Answers   Microsoft, Oracle, TCS,

---

How to define Data Block size ?

2 Answers  

---