Answer / Amit Jain

PL/SQL is not necessarily better than SQL. They are two different things. SQL is a language for querying and manipulating data, while PL/SQL is a procedural programming language used primarily with Oracle Database to build more complex programs.

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,

---

What is bind variable in pl sql?

1 Answers  

---

How many types of triggers are there in pl sql?

1 Answers  

---

What is the purpose of a secondary key?

1 Answers  

---

How to use distinct and count in sql query? Explain

1 Answers  

---

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

---

Explain polymorphism in pl/sql.

1 Answers  

---

How do you write a subquery?

1 Answers  

---

What does select top 1 do in sql?

1 Answers  

---

What is schema in sql example?

1 Answers  

---

what is a view? : Sql dba

1 Answers  

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

1 Answers  

---