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 can you save or place your msg in a table?

0 Answers  

---

Can sql developer connect to db2?

0 Answers  

---

Are pl sql variables case sensitive?

0 Answers  

---

How to access the current value and next value from a sequence?

6 Answers  

---

---

What is trigger in flip flop?

0 Answers  

---

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

Is primary key clustered or nonclustered?

0 Answers  

---

How to select 10 records from a table?

0 Answers  

---

Can you sum a count in sql?

0 Answers  

---

How will you distinguish a global variable with a local variable in pl/sql?

0 Answers  

---