What does “select count(1) from tab” result?

10 Answers   IBM,

---

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

---

what is the Default Libraries for Oracle Report 6i

0 Answers   IBM,

---

How do sql databases work?

0 Answers  

---

How do I count records in sql?

0 Answers  

---

What is Difference Between delete and Truncate?

9 Answers  

---

difference between oracle 8i and oracle 9i

8 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 are pl/sql cursors?

0 Answers  

---

Where not exists in sql?

0 Answers  

---

What can be a size of a pl/sql block? Is there any limit?

2 Answers  

---

What will happen after commit statement ?

2 Answers  

---