title: Spread one row into several by char in SQL ORACLE
body: <p>I want to split the row for several by '|' char. like attached screenshots.
  From:
  <a href="https://i.stack.imgur.com/JbKRY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JbKRY.png" alt="enter image description here" /></a></p>
  <p>to:</p>
  <p><a href="https://i.stack.imgur.com/swlWN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/swlWN.png" alt="enter image description here" /></a></p>