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
- 1632 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is asqueryable?
Explain what is dbms?
What is a unique key and primary key and foreign key?
What is delimiter sql?
Can we use ddl commands in pl sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
i want run a sql query query? which phases are run in a back ground? pls tell me the answer
real time applications of nullif?
What is sql dialect?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
what is offset-fetch filter in tsql? : Transact sql
Explain uses of cursor.
-
Oracle (3253) - 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)
