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  

---

Is sql better than excel?

0 Answers  

---

What is difference between select statement and cursor

3 Answers   JDA,

---

Where the sql database files are stored?

0 Answers  

---

How to prepare for oracle pl sql certification?

0 Answers  

---

What is a function in oracle pl sql?

0 Answers  

---

what are the different index configurations a table can have? : Sql dba

0 Answers  

---

Does truncate free space?

0 Answers  

---

Sql technical questions

0 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

what is top in tsql? : Transact sql

0 Answers  

---