What is pl sql quora?

0 Answers  

---

What is a join?Explain the different types of joins?

6 Answers   Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,

---

what is data control language? : Sql dba

0 Answers  

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

..........refers to the disk mirroring

2 Answers   iFlex,

---

---

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 the parts of a sql statement?

0 Answers  

---

What is difference between hql and native sql?

0 Answers  

---

What is a pl/sql block?

0 Answers  

---

how to findout the 100th maximum salary

28 Answers   Amdocs,

---

how many sql dml commands are supported by 'mysql'? : Sql dba

0 Answers  

---

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---