What will you get by the cursor attribute sql%notfound?

0 Answers  

---

What are the qualities of 2nf?

0 Answers  

---

hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance

1 Answers  

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

What is package in pl sql?

0 Answers  

---

How do I count records in sql?

0 Answers  

---

How do you use collections in procedure to return the resultset?

0 Answers  

---

What normalization means?

0 Answers  

---

How do you update a table in sql?

0 Answers  

---

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

---

What is execute immediate?

0 Answers  

---

Why is theta join required?

0 Answers  

---