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
- 1049 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary
Can we use out parameter in function?
What are the different types of database management systems?
can we delete the trigger in a view? if yes why if not why?
What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.
What kind of join is join?
What is procedure explain with example?
When do we use triggers?
What is a database trigger ? Name some usages of database trigger ?
What is a column in a table?
Is a secondary key the same as a foreign key?
What are keys in sql?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
