How do I print output in new line in PL/SQL?

Question

How do I print a new line in PL/SQL? I'm after something similar to '\n' in the C language.

Example:

begin      dbms_output.put_line('Hi, good morning friends');  end; 

I need the output is like this:

hi, good  morning friends 

Answer 1

You can concatenate the CR and LF:

chr(13)||chr(10) 

(on windows)

or just:

chr(10) 

(otherwise)

dbms_output.put_line('Hi,'||chr(13)||chr(10) ||'good' || chr(13)||chr(10)|| 'morning' ||chr(13)||chr(10) || 'friends');