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

1 Answers  

---

What are different sql data types?

0 Answers  

---

what is subquery? : Sql dba

0 Answers  

---

What are the qualities of 2nf?

0 Answers  

---

What is pl sql package?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

How do you get column names only for a table (sql server)?

0 Answers  

---

Can we join more than 2 tables in sql?

0 Answers  

---

What is pivot table in sql?

0 Answers  

---

Does truncate require commit?

0 Answers  

---

How to maintain the history of code changes of pl/sql?

3 Answers  

---

What is db journal file?

0 Answers  

---