title: Give order to some elements for every user ORACLE
body: <p>I have table consisting of notes for every user which looks like this:</p>
  
  <pre><code>user_id    note_id
  -------    -------
        1       1232
        1       1246
        1       1223
        2       3342
        2       2134
        3       3212
        3       1243
      ...        ...
  </code></pre>
  
  <p>And now i like to implement an ordering mechanism which would allow user to arrange these notes in a user-specified way so that the final table would look something like this:</p>
  
  <pre><code>user_id    note_id  note_order
  -------    -------  ----------
        1       1232          1
        1       1246          2
        1       1223          3
        2       3342          1
        2       2134          2
        3       3212          1
        3       1243          2
      ...        ...        ...
  </code></pre>
  
  <p>Of course after adding this column it has NULL values and I'm not allowed to create any more sequences in the database. Is there any way in ORACLE to achieve this goal? </p>
  
  <p>I'd like the values in order column to start from 1 to the number of notes for every user and preferably do this in one update statement. If it`s impossible this way what would be the best construction for an PL/SQL loop or is there any other effective way to do this?</p>
  
  <p>Looking forward to any possible help.</p>