What plvcmt and plvrb does in pl/sql?

0 Answers  

---

How do I edit a trigger in sql developer?

0 Answers  

---

how u can find the n row from a table?

19 Answers   Tech Mahindra,

---

What is the difference between inner join and outer join?

0 Answers  

---

How run sql*plus commands that are stored in a local file?

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,

---

How to return an array from java to pl/sql?

0 Answers  

---

What is the difference between jpql and sql?

0 Answers  

---

How many sectors are in a partition?

0 Answers  

---

What is sql trigger example?

0 Answers  

---

What are the methods of filing?

0 Answers  

---

How to find the count of letter "L" in HELLO

7 Answers   HP,

---