What is scalar function?

0 Answers  

---

select top 3 sal from each dept?

17 Answers   IBM, TCS,

---

What is a dynamic query?

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,

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

---

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 Answers  

---

What is the reports view in oracle sql developer?

0 Answers  

---

How does postgresql compare to mysql?

0 Answers  

---

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

---

What are the sql commands?

0 Answers  

---

Which data type is a composite type?

0 Answers  

---

how to create a new table by selecting rows from another table in mysql? : Sql dba

0 Answers  

---