What are pl sql procedures?

0 Answers  

---

what is the use of double ampersand (&&) in sql queries?

0 Answers  

---

What do you mean by field in sql?

0 Answers  

---

How to test for null values?

0 Answers  

---

What is rowtype?

0 Answers  

---

---

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

---

How do you identify a primary key?

0 Answers  

---

Can a composite key be null?

0 Answers  

---

What is coalesce in sql?

0 Answers  

---

what is table? : Sql dba

0 Answers  

---

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

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---