Why are cursors used?

0 Answers  

---

What is multiple columns?

0 Answers  

---

Can we perform dml on view?

0 Answers  

---

what is inline command?

2 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 is the differnce between view and materialized view

4 Answers   TCS,

---

How many LONG columns are allowed in a table?

6 Answers   CTS,

---

How do I view a sql database?

0 Answers  

---

Can procedure in package be overloaded?

0 Answers   EXL,

---

How many sql core licenses do I need?

0 Answers  

---

With out using count() function. How to the find total number of rows in a table?

6 Answers  

---

how to findout the 100th maximum salary

28 Answers   Amdocs,

---