title: PL/SQL: Center query RESULTS
body: <p>I've googled all I know how to Google. I need some new eyes to look at this.</p>
  
  <p>I am trying to center the RESULTS of a query.  Here is what I have so far ...</p>
  
  <pre><code>    set lines 2000 pages 2000
      COLUMN total HEADING "Total" FORMAT A20 JUSTIFY CENTER
      COLUMN sending_fi HEADING "Sending M" FORMAT A20 JUSTIFY CENTER
      COLUMN receiving_fi HEADING "Receiving M" FORMAT A20 JUSTIFY CENTER
      COLUMN status HEADING "Payment Status" FORMAT A20 JUSTIFY CENTER
      SET UNDERLINE =
      select
          count(*) as "Total",
          p.sending_fi,
          p.receiving_fi,
          p.status
      from
          my_schema.my_table p
      where
          p.match_date
              between
                  to_date
                      (
                          '2017/10/26:00:00:00',
                          'yyyy/mm/dd:hh24:mi:ss'
                      )
              and
                  to_date
                      (
                          '2017/10/28:23:59:59',
                          'yyyy/mm/dd:hh24:mi:ss'
                      )
      and
          p.expedited='1'
      and
          p.status='DELIVERED'
      group by
          p.sending_fi,
          p.receiving_fi,
          p.status
      order by
          1
          DESC
      ;
  </code></pre>
  
  <p>Which produces this output ...</p>
  
  <p><code>
         Total              Sending M           Receiving M         Payment Status<br>
  ==================== ==================== ==================== =================
                266759 BAC                  BAC                  DELIVERED<br>
                 49954 JPM                  BAC                  DELIVERED<br>
                 45194 BAC                  JPM                  DELIVERED<br>
                 25990 WFC                  BAC                  DELIVERED<br>
                 25676 JPM                  WFC                  DELIVERED<br>
                 24120 WFC                  JPM                  DELIVERED<br>
                 23565 BAC                  WFC                  DELIVERED<br>
  </code></p>
  
  <p>The COLUMN HEADERS (names) are centered, but for the life of me, I can't figure out how to center the results.</p>
  
  <p>I'm a non-privileged user (all i ever really do are select update and insert), with very limited SQL skills. Please be gentle in your suggestions.</p>