What is rownum and rowid?

0 Answers  

---

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,

---

explain what is mysql? : Sql dba

0 Answers  

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

---

Can you have more than one trigger on a table?

0 Answers  

---

What is keys and its types?

0 Answers  

---

what is clause? : Sql dba

0 Answers  

---

What is a boolean in sql?

0 Answers  

---

what is foreign key? : Sql dba

0 Answers  

---

what is data manipulation language? : Sql dba

0 Answers  

---

What is bulk collections?

2 Answers  

---

What are basic techniques of indexing?

0 Answers  

---