I would like to take the following output:
First Name: Sam Last Name: Smith

and embed a carriage return between 'Sam' and 'Last'
So that my output text looks as follows:

First Name: Sam
Last Name: Smith

How can I accomplish this? Thanks - Julie

SQL> SELECT 'First Name: Sam' || CHR(10) || 'Last Name: Smith' text
  2  FROM   DUAL
  3  /
  
TEXT
--------------------------------
First Name: Sam
Last Name: Smith
  
  
SQL>