What port does sql server use?

0 Answers  

---

What is procedure explain with example?

0 Answers  

---

what is ref cursor in pl/sql?

3 Answers  

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

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,

---

How do I run a sql query in pgadmin 4?

0 Answers  

---

How can a function retun more than one value in oracle with proper example?

0 Answers  

---

Is sqlexception checked or unchecked?

0 Answers  

---

How to rename a column in the output of sql query?

0 Answers  

---

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

what is an index? : Sql dba

0 Answers  

---

What does cursor do in sql?

0 Answers  

---