Enlist some predefined exceptions?

0 Answers  

---

Why are indexes and views important to an organization?

0 Answers  

---

What are Global Temporary tables

3 Answers   IBM, TCS,

---

how can we repair a mysql table? : Sql dba

0 Answers  

---

How can I tell if sql is running?

0 Answers  

---

why we use nocopy?

2 Answers   Polaris,

---

How are sql commands classified?

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 a subquery in sql?

0 Answers  

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---

What language is oracle sql developer?

0 Answers  

---

How to assign sql query results to pl sql variables?

0 Answers  

---