How does left join work in sql?

0 Answers  

---

What is sql and explain its components?

0 Answers  

---

What is offset in sql query?

0 Answers  

---

What is the difference between truncate and drop statements?

0 Answers  

---

Is left join same as inner join?

0 Answers  

---

---

scope of exception handling in plsql

4 Answers   Wipro,

---

what is constraining table?

2 Answers  

---

What is cursor and its types?

0 Answers  

---

Is json a nosql?

0 Answers  

---

How many types of sql are there?

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 does sql stand for?

0 Answers  

---