title: Output key, value pairs with sqlplus
body: <p>I am using sqlplus to output the content of a table :</p>
  
  <pre><code>select * from my_table;
  </code></pre>
  
  <p>The output is similar to this :</p>
  
  <pre><code>ID
  -------------
  FIELD1
  ----------------
  FIELD2
  ----------------
  someid
  field 1 content
  field 2 content
  </code></pre>
  
  <p>I tried many combinations of the page formatting options. I can format the output in a table by setting <code>head</code>, <code>pages</code>, <code>termout</code>, <code>echo</code>, <code>feed</code> and <code>linesize</code>.</p>
  
  <p>But I would like to output the values in a (key, value) fashion, like this :</p>
  
  <pre><code>ID = someid
  FIELD1 = field 1 content
  FIELD2 = field 2 content
  </code></pre>
  
  <p>Delimiter and formatting is not important, as long as I have one column per line.</p>
  
  <p>Is it possible using only sqlplus ? I would like to avoid scripting this. On this particular machine (an appliance I can't install anythin on) I only have bash, perl and Python 2.4.</p>