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,

---

How to make a copy values from one column to another in sql?

0 Answers  

---

Does sql backup shrink transaction log?

0 Answers  

---

What are the different tcl commands in sql?

0 Answers  

---

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

---

What are the types of queries in sql?

0 Answers  

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

0 Answers  

---

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

---

What is graph sql?

0 Answers  

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

Can we rename a column in the output of sql query?

0 Answers  

---

Is a secondary key the same as a foreign key?

0 Answers  

---