Mention what are different methods to trace the pl/sql code?

0 Answers  

---

How we can update the view?

0 Answers  

---

What is mdb stand for?

0 Answers  

---

What is sql exception?

0 Answers  

---

What is a boolean in sql?

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,

---

What are different functions in sql?

0 Answers  

---

In what condition is it good to disable a trigger?

0 Answers  

---

What is set serveroutput on in pl sql?

0 Answers  

---

Is oracle sql free?

0 Answers  

---

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

---

What are sql objects?

0 Answers  

---