What are the different sql languages?

0 Answers  

---

what does it mean to have quoted_identifier on? : Sql dba

0 Answers  

---

How much ram can sql express use?

0 Answers  

---

Why do we use function in pl sql?

0 Answers  

---

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

---

---

What is sql prepared statement?

0 Answers  

---

What are user defined functions?

0 Answers  

---

what is a composite primary key ? : Sql dba

0 Answers  

---

What is the difference between sql/pl-sql/embeded sql?

3 Answers  

---

What are the different types of functions in sql?

0 Answers  

---

what is not null constraint? : 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,

---