how to escape special characters in sql statements? : Sql dba

0 Answers  

---

Why do we use cursors?

0 Answers  

---

What is 19 null in sql?

0 Answers  

---

I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 Answers  

---

What is the difference between partitioning and sharding?

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 exception? What are the types of exceptions?

0 Answers  

---

what is 'mysqlimport'? : Sql dba

0 Answers  

---

Which table is left in left join?

0 Answers  

---

What is dml and ddl?

0 Answers  

---

What is the requirement of self-join?

0 Answers  

---

What is an ndf file?

0 Answers  

---