Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Column split in to rows with delimeter "|" value have null values

user7324681Aug 2 2020 — edited Aug 2 2020

Hi

Currently am using oracle 12c version

my current date have below format

  

IDSAMPLE
1|||aa|bb||ccc

select '1' as id,'|||aa|bb||ccc' as sample from dual

expected output like .i have used regular expression its skipping the null value

   

IDABCDEFGH
1 aabb cc
This post has been answered by mathguy on Aug 2 2020
Jump to Answer
Comments
Post Details
Added on Aug 2 2020
3 comments
1,356 views