title: Oracle SQL Developer: How to display full column names in textual SELECT output
body: <p>Given this schema and data:</p>
  
  <pre><code>create table my_table
  (
      my_key   number(8,0),
      string_1 varchar2(7),
      string_2 varchar2(7)
  )
  /
  commit;
  insert into my_table values (1, 'hello', 'bonjour');
  commit;
  </code></pre>
  
  <p>When I <code>select * from my_table</code> I get this output:</p>
  
  <pre><code>    MY_KEY STRING_ STRING_
  ---------- ------- -------
           1 hello   bonjour
  </code></pre>
  
  <p>As you can see, the column names it gives me are:</p>
  
  <ul>
  <li>MY_KEY</li>
  <li>STRING_</li>
  <li>STRING_</li>
  </ul>
  
  <p>I would like to see the complete column names in the text output (F5).  I know I can get the output in a nice grid (F9) with the full column names, but I want the <strong>data and full column names in text</strong>.</p>
  
  <p>I would much prefer a solution which is not specific to this table and these columns.  A single solution which fixes the output for all my tables would be much preferred to a one-off fix to these 2 particular columns.</p>