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  

---

using comand prompt how can import table data and table space with example

2 Answers  

---

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

---

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

---

how to return query output in html format? : Sql dba

0 Answers  

---

What are local and global Indexes and where they are useful.

0 Answers  

---

What is an exception in pl/sql?

0 Answers  

---

What is the difference between pl and sql?

0 Answers  

---

How to display the contents of a current record fetched in a reference cursor?

2 Answers  

---

Is vs as in pl sql?

0 Answers  

---

how to create a database in oracle?

3 Answers  

---

How do I kill a query in postgresql?

0 Answers  

---