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 are the differences between char and nchar? : Sql dba

0 Answers  

---

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers  

---

What are the different types of database management systems?

0 Answers  

---

Explain architecture of sql server notification services?

0 Answers  

---

can i create trigger on synonym is it possible or not please help me

4 Answers   CGI,

---

what are the 'mysql' command line options? : Sql dba

0 Answers  

---

How can you tell the difference between an index and a view?

0 Answers  

---

what is a record in a database ? : Sql dba

0 Answers  

---

what is d diff between grant,commit,rollback n savepoint

1 Answers  

---

how to write utl file pkg in SQL

1 Answers   Oracle,

---

What is record type in pl sql?

0 Answers  

---