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  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

How many commands are in sql?

0 Answers  

---

What is delimiter sql?

0 Answers  

---

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---

Is left join same as inner join?

0 Answers  

---

how will u find statistics of a database objects?

2 Answers   iFlex,

---

Explain the update statement in sql

0 Answers  

---

Mention what is the plv (pl/vision) package offers?

0 Answers  

---

How to use sql statements in pl/sql?

0 Answers  

---

What are the basic sql commands?

0 Answers  

---