What is pivot query?

0 Answers  

---

Which data type is a composite type?

0 Answers  

---

what are rollup and cube in t-sql? : Transact sql

0 Answers  

---

Are subqueries better than joins?

0 Answers  

---

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,

---

---

What is the use of time stamp in select statement?

1 Answers   TCS,

---

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,

---

Which version of sql do I have?

0 Answers  

---

what is innodb? : Sql dba

0 Answers  

---

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

---

What are pl/sql exceptions? Tell me any three.

1 Answers  

---

What is foreign key and example?

0 Answers  

---