title: read from text file line by line into substring with SQLplus
body: <p>I have the following SQLplus query that works perfectly fine for reading from a text file that data are sorted in the same line and separated by ' '. The question is How could I modify this query in order to be able to read from a text file that data are sorted in row by row? I tried '\n' but didn't work</p>
  <p><a href="https://i.stack.imgur.com/IYNPV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IYNPV.png" alt="" /></a></p>