How to remove duplicate rows from a table?.

3 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 all the difference between Like and Contains ?

2 Answers   LG Soft,

---

What is a heap in sql?

0 Answers  

---

What are analytic functions in sql?

0 Answers  

---

How to display the current date in sql?

0 Answers  

---

What is the difference between a procedure and a function?

0 Answers  

---

What are the most important ddl statements in sql?

0 Answers  

---

What is a common use of group by in sql?

0 Answers  

---

What Is a Trigger? How Do You Use It?

3 Answers  

---

How do I run a sql script?

0 Answers  

---

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

---