title: Ugly formatting in SQL*Plus
body: <p>It is really annoying that when I run a select command in SQL*Plus such as:</p>
  
  <pre><code>SELECT * FROM books;
  </code></pre>
  
  <p>The output is really badly formatted and unreadable (row cells are not in a row but separated by line breaks etc):</p>
  
  <p><img src="https://i.stack.imgur.com/kH1KZ.png" alt="enter image description here"></p>
  
  <p>How can I configure it to show SELECT results in a nicer way?</p>
  
  <p>EDIT:</p>
  
  <p>This is my login.sql file contents:</p>
  
  <pre><code>SET ECHO OFF
  SET SERVEROUTPUT ON SIZE 1000000
  SET PAGESIZE 999
  SET LINESIZE 132
  </code></pre>
  
  <p>EDIT2:</p>
  
  <p>Affer increasing the LINESIZE:</p>
  
  <pre><code>SET LINESIZE 32000
  </code></pre>
  
  <p>It now looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/a6SZA.png" alt="enter image description here"></p>