How will you distinguish a global variable with a local variable in pl/sql?

0 Answers  

---

What is Difference Between delete and Truncate?

9 Answers  

---

Can we group by two columns in sql?

0 Answers  

---

What is synonyms?

0 Answers  

---

what is the syntax for using sql_variant_property? : Transact sql

0 Answers  

---

---

Which is better trigger or stored procedure?

0 Answers  

---

Explain the purpose of %type and %rowtype data types with the example?

0 Answers  

---

How do I save the results of sql query in a file?

0 Answers  

---

Can you load data into multiple tables at once? : aql loader

0 Answers  

---

Explain what is dbms?

0 Answers  

---

What is the best partition size for windows 10?

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,

---