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 the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

---

what is acid property in database? : Sql dba

0 Answers  

---

which operator is used in query for pattern matching? : Sql dba

0 Answers  

---

What is the differnce between view and materialized view

4 Answers   TCS,

---

---

What is procedure explain with example?

0 Answers  

---

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

---

What is the different between Stored Procedure and Procedure?

7 Answers   Informatica, MIS,

---

How do temporal tables work?

0 Answers  

---

Why does sql need a server?

0 Answers  

---

Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  

---

What is Referential Integrity?

3 Answers  

---