use of IN/ANY/ALL

5 Answers   Ramco,

---

what are myisam tables? : Sql dba

0 Answers  

---

Does group by remove duplicates?

0 Answers  

---

How to sort the rows in sql.

0 Answers  

---

Explain the uses of a database trigger?

0 Answers  

---

---

What is sqlca in db2?

0 Answers  

---

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

---

What is trigger explain with example?

0 Answers  

---

How you will create Toad Function?

1 Answers  

---

tell me about various levels of constraint. : Sql dba

0 Answers  

---

What are the indexing methods?

0 Answers  

---

How to find 3rd highest salary of an employee from the employee table in sql?

0 Answers  

---