title: Counter Simulation - Oracle SQL
body: <p>I have a scenario where I need to do this: </p>
  
  <p>TABLE: <code>UDA_VALUES</code>
  It has three fields: </p>
  
  <pre><code>UDA_ID, UDA_VALUE_ID, UDA_VALUE_DESC
  </code></pre>
  
  <p>The Data for the table is like: </p>
  
  <pre><code>UDA_ID   UDA_VALUE_ID
    1          100
    1          243
    2          264
    3          564
    3          634
    3          774   
  </code></pre>
  
  <p>I need to show the data like:</p>
  
  <pre><code>UDA_ID    COUNTER   UDA_VALUE_ID
    1          1            100
    1          2            243
    2          1            264
    3          1            564
    3          2            634
    3          3            774
  </code></pre>
  
  <p>How can I write the Counter?</p>