Oracle 12 - How to identify duplicates with increment?

Question

I want to differentiate duplicate values in my query by adding an increment or a count of some sort.

The idea is to concatenate my two columns to create a new unique reference.

I tried this :

SELECT 
    value, 
    COUNT(*) OVER (PARTITION BY value) value_incr
FROM table

and got the following result :

| value | value_incr |
| --- | --- |
| a | 1 |
| b | 3 |
| b | 3 |
| b | 3 |
| c | 2 |
| c | 2 |
| d | 1 |

But what I would like to get is :

| value | value_incr |
| --- | --- |
| a | 1 |
| b | 1 |
| b | 2 |
| b | 3 |
| c | 1 |
| c | 2 |
| d | 1 |

Is there a way to differentiate my duplicates in Oracle 12 ?

My best solution for now is to add a ROWNUM column, but it's not really satisfying.

Thank you