What is the basic structure of an sql?

0 Answers  

---

What is an Exception ? What are types of Exception ?

2 Answers  

---

Can we write dml inside a function in sql server?

0 Answers  

---

What is CYCLE/NO CYCLE in a Sequence?

2 Answers  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

---

What are Global Temporary tables

3 Answers   IBM, TCS,

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

Why is normalization important?

0 Answers  

---

Which is faster joins or subqueries?

0 Answers  

---

What is pls_integer in pl sql?

0 Answers  

---

What is a cursor for loop ?

4 Answers  

---

What does the hierarchical profiler does?

0 Answers  

---