title: How to prettify the output coming from the SELECT query in command prompt?
body: <p>I ran the simple <code>select</code> query in the command prompt,but the output rows are not coming in a single line. See below:</p>
  
  <pre><code>SQL&gt; set pagesize 2000
  SQL&gt; select * from xtern_empl_rpt ;
  
  EMP LAST_NAME
  --- --------------------------------------------------
  FIRST_NAME                                         SSN
  -------------------------------------------------- ---------
  EMAIL_ADDR
  --------------------------------------------------------------------------------
  
  YEARS_OF_SERVICE
  ----------------
  001 Hutt
  Jabba                                              896743856
  jabba@thecompany.com
                18
  
  002 Simpson
  Homer                                              382947382
  homer@thecompany.com
                20
  
  003 Kent
  Clark                                              082736194
  superman@thecompany.com
                 5
  
  004 Kid
  Billy                                              928743627
  billythkid@thecompany.com
                 9
  
  005 Stranger
  Perfect                                            389209831
  nobody@thecompany.com
                23
  
  006 Zoidberg
  Dr                                                 094510283
  crustacean@thecompany.com
                 1
  
  
  6 rows selected.
  
  SQL&gt;
  </code></pre>
  
  <p>Could you please help me to make each rows in a single line?</p>
  
  <p><em><strong>Edit</em></strong></p>
  
  <p>I tried below,but still is not prettified.</p>
  
  <pre><code>SQL&gt; SET LINESIZE 4000
  SQL&gt; select * from xtern_empl_rpt ;
  
  EMP LAST_NAME                                          FIRST_NAME
                            SSN       EMAIL_ADDR
                                                           YEARS_OF_SERVICE
  --- -------------------------------------------------- -------------------------
  ------------------------- --------- --------------------------------------------
  -------------------------------------------------------- ----------------
  001 Hutt                                               Jabba
                            896743856 jabba@thecompany.com
                                                                         18
  002 Simpson                                            Homer
                            382947382 homer@thecompany.com
                                                                         20
  003 Kent                                               Clark
                            082736194 superman@thecompany.com
                                                                          5
  004 Kid                                                Billy
                            928743627 billythkid@thecompany.com
                                                                          9
  005 Stranger                                           Perfect
                            389209831 nobody@thecompany.com
                                                                         23
  006 Zoidberg                                           Dr
                            094510283 crustacean@thecompany.com
                                                                          1
  
  6 rows selected.
  
  SQL&gt;
  </code></pre>