How do you go back in sql?

0 Answers  

---

How do I get sql certification?

0 Answers  

---

What is right join 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,

---

Define commit, rollback and savepoint?

0 Answers  

---

What is Collation Sensitivity ? What are the various type ?

0 Answers  

---

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

---

Show code of a cursor for loop.

0 Answers  

---

How sql query is executed?

0 Answers  

---

What is the difference between sql, mysql and sql server?

0 Answers  

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

Which kind of parameters cannot have a default value in pl sql?

0 Answers  

---