How to get a value according to its number of occurrence

I have a Key-Value table like this:

How to get a value according to the occurrence index of the key.

I only got the key index using

select INSTR ( key,
       'key5<>'
      , 1,1
      )
  from table ;

How should I get the complementary value to the delimiter occurrence?

I want to get the parallel value to ‘key5’ which is 961.

You need to sign in to view this answers