What if we write return in procedure?

0 Answers  

---

Can ddl statements be used in pl/sql?

0 Answers  

---

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

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 pragma statement?

0 Answers  

---

What are the Restrictions on Cursor Variables?

2 Answers  

---

how are mysql timestamps seen to a user? : Sql dba

0 Answers  

---

What is difference between sql and oracle?

0 Answers  

---

Is time a data type in sql?

0 Answers  

---

What is sqlcontext?

0 Answers  

---

What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,

---