How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

---

Is sql procedural language?

0 Answers  

---

What does where 1/2 mean in sql?

0 Answers  

---

What is asqueryable?

0 Answers  

---

what is a control file ? : Sql dba

0 Answers  

---

---

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 Answers  

---

What is indexing in sql and its types?

0 Answers  

---

What is materialised View?

2 Answers   IBM,

---

Why use stored procedures?

0 Answers  

---

How do I run a pl sql procedure in sql developer?

0 Answers  

---

In pl/sql, what is bulk binding, and when/how would it help performance?

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,

---