Define overloaded procedure?

0 Answers  

---

What is loop in pl sql?

0 Answers  

---

What is pl sql variable?

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,

---

Types of cursors and explanation each of them ?

4 Answers   DELL,

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  

---

How can you save or place your msg in a table?

0 Answers  

---

Are pl sql variables case sensitive?

0 Answers  

---

what is self join and what is the requirement of self join? : Sql dba

0 Answers  

---

What are conditional predicates?

0 Answers  

---

What is an Exception ? What are types of Exception ?

2 Answers  

---

Is sql a dbms?

0 Answers  

---