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,

---

Can we write dml inside a function in sql server?

0 Answers  

---

Explain the savepoint statement.

0 Answers  

---

What is memory optimized table?

0 Answers  

---

How can I tell if sql is running?

0 Answers  

---

---

What is rownum and rowid?

0 Answers  

---

Explain unique key in sql.

0 Answers  

---

how do you control the max size of a heap table? : Sql dba

0 Answers  

---

What are secondary keys?

0 Answers  

---

What is acid property in a database?

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 execution plan in sql?

0 Answers  

---