Which is better stored procedure or query?

0 Answers  

---

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,

---

When is the update_statistics command used?

0 Answers  

---

Explain select statements in sql?

0 Answers  

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

what is a cursor

9 Answers   IBM, TCS, Wipro,

---

What are the types of join in sql?

0 Answers  

---

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

Why we use sql profiler?

0 Answers  

---

what is the difference between primary key and unique key? : Sql dba

0 Answers  

---

What is a schema? How is it useful in sql servers?

0 Answers  

---

What is a mutating table and a constraining table?

0 Answers  

---