what is the command line end user interface - mysql? : Sql dba

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,

---

How can we find duplicate records in a table?

0 Answers  

---

What is pls_integer in pl sql?

0 Answers  

---

What are the datatypes a available in PL/SQL ?

2 Answers  

---

---

Is primary key is clustered index?

0 Answers  

---

What is sql engine in oracle?

0 Answers  

---

What are the 3 types of behavioral triggers?

0 Answers  

---

How do I run a program in pl sql?

0 Answers  

---

What can you do with pl sql?

0 Answers  

---

What is a left inner join?

0 Answers  

---

How do I upgrade sql?

0 Answers  

---