sql query, from the string ( 'abcdaefgahj' ), where I have to change the 3rd occurance of 'a' with replaced by 'o'. output will be look like ('abcdaefgohj')

SELECT REGEXP_REPLACE('abcdaefgahj', 'a','o', 1, 3) RESULT
FROM dual;