Line Breaks

To get a line break in your output data, use 'Chr(10).' It must be concatenated to the columns it's between

  1* Select 'Hi' || Chr(10) || 'There' From Dual
SQL> /

Hi
There