title: Add auto increment column to an existing table ordered by created time
body: <p>I have below table in Oracle db (ATP db)</p>
  <pre><code>create table record(
   record_id raw(16) primary key,
   dataset_id raw(16) not null,
  
   name varchar2(127) not null,
   time_created timestamp not null,
   CONSTRAINT record_fk_dataset_id foreign key (dataset_id) references dataset(dataset_id),) 
  partition by reference (record_fk_dataset_id);
  </code></pre>
  <p>I would like to add new auto-increment column id in sequence with time_created, eg. records are created in this order of time_created 1st record at 02/12/2021 12:37:37 PM 2nd record at 02/12/2021 12:40:45 PM</p>
  <p>1st record to get id as 1 and 2nd id as 2.</p>
  <p>I have some data in record table already.</p>
  <p><strong>Edit:</strong>
  time_created can have duplicate entries too.</p>