title: How to arrange or format the table results in Oracle SQL Plus
body: <p>I started learning Oracle and I've been gone through different types of examples. But from the beginning I have an issue that how can we arrange the retrieve table in well formatted view. I am using SQL Plus.</p>
  
  <p><a href="https://i.stack.imgur.com/bQoHg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bQoHg.png" alt="enter image description here"></a></p>
  
  <p>I attached a image of the way I get the output. I want the output table in a proper table view ( <em>Organized columns and rows</em> ).</p>
  
  <pre><code>SELECT DISTINCT c.name,
                  i.company.company AS stock_name,
                  i.company.current_price AS cur_price,
                  i.company.last_dividend AS last_devident,
                  i.company.earning_pershare AS eps
    FROM client_table_c c, TABLE (c.investments) i
  </code></pre>