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,

---

Why do you partition data?

0 Answers  

---

Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  

---

Is delete faster than truncate?

0 Answers  

---

What is the difference between a primary key and a clustered index?

0 Answers  

---

---

How to read/write files from pl/sql?

0 Answers  

---

Where is pl sql used?

0 Answers  

---

what is a foreign key ? : Sql dba

0 Answers  

---

How do you handle exceptions. Give the syntax for it?

1 Answers   BCL, Microsoft,

---

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---

What is procedure and function in sql?

0 Answers  

---

What is a field in a database?

0 Answers  

---