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?

2 Answers  

---

Can we perform dml in function?

0 Answers  

---

What are the subsets of sql?

0 Answers  

---

How do you identify a primary key?

0 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

Name the tables where characteristics of Package, procedure and functions are stored ?

3 Answers  

---

What are data types in pl sql?

0 Answers  

---

Which sql statement is used to delete data from a database?

0 Answers  

---

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 Answers  

---

What is sql trigger example?

0 Answers  

---

in materialized view the structure will create immediately or not?

2 Answers   iFlex,

---

Where can I learn sql for free?

0 Answers  

---