title: Oracle SQLPlus: print column titles in header when there is no output rows (showing "no rows selected" message)
body: <p>I am running an SQL command from SQLPlus command line and getting no rows.</p>
  
  <p>Example:</p>
  
  <pre><code>select * from users;
  
  no rows selected
  </code></pre>
  
  <p>I want to <strong>show the column names even if there is no rows in the table</strong>.</p>
  
  <p>I tried:</p>
  
  <pre><code>set heading on;
  </code></pre>
  
  <p>Still no headers appeared after running the query!</p>
  
  <p>I want a straight command, not tricks like concatenating fake records at the start/end of the query by union.</p>