What is pl sql in oracle?

0 Answers  

---

how to create a test table in your mysql server? : Sql dba

0 Answers  

---

How do you retrieve the second highest salary from a table?

3 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

Which is faster subquery or join?

0 Answers  

---

In a table only one column how to update rows

5 Answers   Microsoft,

---

What pl/sql package consists of?

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,

---

What is a recursive join sql?

0 Answers  

---

Is pl sql and postgresql same?

0 Answers  

---

What does the file extension accdb stand for?

0 Answers  

---