What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,

---

Which type of cursor is used to execute the dml statement?

0 Answers  

---

How to get each name only once from an employee table?

0 Answers  

---

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

---

What are the most important characteristics of pl/sql?

0 Answers  

---

What is different between union and minus?

7 Answers   Accenture, TCS,

---

What is foreign key in sql with example?

0 Answers  

---

What is linq to sql?

0 Answers  

---

What is over () in sql?

0 Answers  

---

What is the purpose of normalization?

0 Answers  

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---