what is top in tsql? : Transact sql

0 Answers  

---

Does oracle use sql?

0 Answers  

---

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

---

How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

What is the difference between Union and Union all. Which is faster.

0 Answers  

---

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

---

What is the use of triggers?

0 Answers  

---

How can we implement rollback or commit statement in a trigger?

0 Answers  

---

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,

---

what is data integrity? : 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,

---

What is the process of copying data from table a to table b?

0 Answers  

---