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  

---

sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)

1 Answers   Fidelity, Oracle,

---

What are the types pl/sql code blocks?

0 Answers  

---

What is left join example?

0 Answers  

---

Explain the difference in execution of triggers and stored procedures?

0 Answers  

---

what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,

---

What is the use of non clustered index?

0 Answers  

---

What does count (*) do in sql?

0 Answers  

---

Can we join two tables without common column?

0 Answers  

---

what are the types of join and explain each? : Sql dba

0 Answers  

---

can i write pl/sql code in a package

2 Answers  

---

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

---