title: SQLPLUS TRIM and COLUMN formatting
body: <p>I have just executed a PL/SQL procedure and have the output:</p>
  
  <p>FirstName               LastName      Role        Quote</p>
  
  <p>what I am wanting to do is use trim and column formatting to output the information like below so that first and last name appear on one row and then role and quote on the next row which are to be separated by a |</p>
  
  <p>FirstName LastName</p>
  
  <p>|Role    | Quote     |</p>
  
  <p>I am not sure how to do this and any help on this would be appreciated </p>