what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

What are the most important characteristics of pl/sql?

0 Answers  

---

What is field delimiter?

0 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

Does db2 use sql?

0 Answers  

---

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

---

Do we need commit after truncate?

0 Answers  

---

What are types of joins?

0 Answers  

---

What is composite primary key in sql?

0 Answers  

---

Why function is used in sql?

0 Answers  

---