how do you tune the slow running queries in oracle db , explain the methodology

0 Answers  

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

How to write html code in pl sql?

0 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

What is your daily office routine?

0 Answers   Data Vision,

---

What do you mean by dbms? What are its different types?

0 Answers  

---

What is composite data type in pl sql?

0 Answers  

---

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

---

How can get second highest salary in sql?

0 Answers  

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

---

What are all the difference between Like and Contains ?

2 Answers   LG Soft,

---