How would you optimize a slow SQL query?

1 Answers  

---

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,

---

What are the differences between blob and clob in oracle?

0 Answers  

---

How remove data files before opening a database?

0 Answers  

---

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,

---

How do I recompile a procedure in oracle?

0 Answers  

---

Explain enable novalidate constraint.

0 Answers  

---

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 Answers  

---

What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,

---

What are advantages of dateset in datastage?

0 Answers   iGate,

---

How can we find the size of a database?

2 Answers  

---

Can anyone give me information about oracle certification

1 Answers  

---