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

Locked Post

New comments cannot be posted to this locked post.

Locked due to inactivity on Sep 19 2018

Added on Aug 22 2018

#sql-pl-sql

9 comments

131 views