i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---

how is myisam table stored? : Sql dba

0 Answers  

---

What are different types of triggers?

0 Answers  

---

What is user defined functions?

0 Answers  

---

What has stored procedures in sql?

0 Answers  

---

What is the difference between join and union.

27 Answers   3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

---

How do I copy a table in sql?

0 Answers  

---

What is output spooling in sql*plus?

0 Answers  

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

how to rename an existing column in a table? : Sql dba

0 Answers  

---

What are the Restrictions on Cursor Variables?

2 Answers  

---

when is the use of update_statistics command? : Sql dba

0 Answers  

---