Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1587 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is rename in sql?
Is sql a scripting language?
How delete all data from table in sql?
Is oracle sql free?
Explain mutating table error.
What is sql dialect?
what is the use of set statement in tsql? : Transact sql
What is sql partition function?
How do I count records in sql?
What do you mean by “trigger” in sql?
How does cross join work?
What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
