Home » Other » Marketplace » Column to Rows - Number Seprated By Any Character
|
|
Re: Column to Rows - Number Seprated By Any Character [message #501233 is a reply to message #501222] |
Mon, 28 March 2011 01:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/6b55d8588e485701bbc36bb0f3f1a376?s=64&d=mm&r=g) |
Paules
Messages: 128 Registered: March 2011 Location: United Arab Emirates
|
Senior Member |
|
|
Hai,
Try this Query. Hope it will be helpful to u.
SELECT TRIM( SUBSTR ( txt
, INSTR (txt, ',', 1, LEVEL ) + 1
, INSTR (txt, ',', 1, LEVEL+1) - INSTR (txt, ',', 1, LEVEL) -1
)
)
AS token
FROM ( SELECT ','||
(SELECT TRANSLATE('374627467(92876/5674)988276+87234687/8974232*3746-984027374[32742-3746236',
'(+/-*[)',
',,,,,,,') outp
FROM dual)||',' AS txt
FROM dual )
CONNECT BY LEVEL <= LENGTH(txt)-LENGTH(REPLACE(txt,',',''))-1
Regards,
Paules.
[Updated on: Mon, 28 March 2011 01:59] by Moderator Report message to a moderator
|
|
|
|
Goto Forum:
Current Time: Sun Jun 30 14:19:00 CDT 2024
|