What is sql clause?

0 Answers  

---

How to take user input in pl sql?

0 Answers  

---

What is sqlerrm?

0 Answers  

---

What is consistency?

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 is procedure explain with example?

0 Answers  

---

full outer join syntax

5 Answers  

---

What is raw datatype in sql?

0 Answers  

---

What is set serveroutput on?

0 Answers  

---

how to rename an existing column in a table? : Sql dba

0 Answers  

---

How do I count rows in sql query?

0 Answers  

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---