Why do we use joins?

0 Answers  

---

What is rownum in sql?

0 Answers  

---

What is Temp Table and type of temp table?

1 Answers   HP, SLK,

---

What is difference between table and view?

0 Answers  

---

Is sql considered coding?

0 Answers  

---

---

Are null values same as that of zero or a blank space?

0 Answers  

---

What does the sign mean in sql?

0 Answers  

---

what is the bond code in materialized view?

0 Answers  

---

What is self-join and what is the requirement of self-join?

0 Answers  

---

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

What is scope of pl sql developer in future?

0 Answers  

---