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,

---

When is a declare statement required?

0 Answers  

---

What does 0 mean in sql?

0 Answers  

---

How do you modify a table in sql?

0 Answers  

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

What is trigger types in sql?

0 Answers  

---

Explain what is a column in a table?

0 Answers  

---

What is schema in sql?

0 Answers  

---

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 Answers  

---

Is time a data type in sql?

0 Answers  

---

What is memory optimized table?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---