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  

---

Is json a nosql?

0 Answers  

---

when MSQL8.0 is in market

0 Answers  

---

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

---

Advantages and disadvantages of stored procedure?

0 Answers  

---

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

0 Answers  

---

Define commit, rollback and savepoint?

0 Answers  

---

What is cascade in sql?

0 Answers  

---

What is sqlca in powerbuilder?

0 Answers  

---

Can instead of triggers be used to fire once for each statement on a view?

0 Answers  

---