title: Instr - Last index of last character
body: <p>I'm using an Oracle 11g DB and I want to find the position of the last character of a string.</p>
  
  <p>For example:</p>
  
  <pre><code>"City=Amsterdam"
  </code></pre>
  
  <p>The string in this case would be "City=", I would like to get the position of the "=".
  I know INSTR(Input,'City=', 1, 1)+4, would kinda work but I am looking for another way.</p>
  
  <p>edit: Basically I want to use a substr function to extract "Amsterdam". But the select statement should be as clean as possible.</p>
  
  <p>What I forgot to mention, the string contains more than "City=Amsterdam", it contains also "Customer=124"</p>
  
  <pre><code>"City=Amsterdam"; "Customer=124"
  </code></pre>