0

I need a function which will convert the input string into row if found comma(,) in string and into columns when pipe(|) operator is found. The result should be like this input string: 'a,b|c,d|' output row 1: a c row2 : b d

asim
  • 37
  • 3
  • 1
    Combine: https://stackoverflow.com/questions/14328621/splitting-string-into-multiple-rows-in-oracle with https://stackoverflow.com/questions/31464275/split-comma-separated-values-to-columns-in-oracle substituting you pipe and comma where appropriate – xQbert Nov 22 '21 at 16:59

0 Answers0