How do I save a stored procedure?

0 Answers  

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

How to return more than one value from a function?

11 Answers   Satyam,

---

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,

---

How can I pass the inner procedure value to outer procedure ?

2 Answers  

---

What does where 1 1 mean in sql?

0 Answers  

---

How do I make my sql query run faster?

0 Answers  

---

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---

explain commit and rollback in mysql : sql dba

0 Answers  

---

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

---

What is java sql driver?

0 Answers  

---