What is the difference between partitioning and sharding?

0 Answers  

---

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,

---

Can we use pl sql in sql server?

0 Answers  

---

How can we optimize a sql query?

0 Answers  

---

What is package in pl sql with an examples?

0 Answers  

---

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

---

what tools available for managing mysql server? : Sql dba

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,

---

How many types of normalization are there?

0 Answers  

---

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---

Explain mutating table error.

0 Answers  

---

what is the difference between pragma exception_init and raise_application_error

1 Answers   Aetins, State Street,

---