Explain the working of primary key?

0 Answers  

---

What is a table in a database?

0 Answers  

---

What does where 1/2 mean in sql?

0 Answers  

---

what are the different functions in sorting an array? : Sql dba

0 Answers  

---

What is cte?

0 Answers  

---

---

what is explain plan?, given an example...

3 Answers   Polaris,

---

How do I truncate a sql log file?

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,

---

what is global variable in pl/sql

1 Answers  

---

Why is theta join required?

0 Answers  

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

0 Answers  

---

What are the different ddl commands in sql?

0 Answers  

---