Skip to Main Content

select the string between the delimter column value

New RootsAug 22 2018 — edited Aug 22 2018

Hi ,

WITH T AS(SELECT 'AZ|BZ|CZ|Y' Data FROM DUAL

UNION ALL

SELECT 'AZ|CX' FROM DUAL

UNION ALL

SELECT 'XE' FROM DUAL

UNION ALL

SELECT 'AW|WE|CR|Y|RD' FROM dual)

I have to change the value to 'N' between third and 4th '|'  delimiters

---Expected output :

AZ|BZ|CZ|N

AZ|CX

XE

AW|WE|CR|N|RD

This post has been answered by Solomon Yakobson on Aug 22 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Sep 19 2018
Added on Aug 22 2018
9 comments
129 views