How do you optimize a query?

0 Answers  

---

what is text? : Sql dba

0 Answers  

---

What is the purpose of the primary key?

0 Answers  

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

---

How can we solve sql error: ora-00904: invalid identifier?

0 Answers  

---

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

---

Can delete statement be rollbacked?

0 Answers  

---

What is varchar sql?

0 Answers  

---

What is sql*loader and what is it used for?

0 Answers  

---

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

---

Why do we use procedures in sql?

0 Answers  

---

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

---