SQL: Regular Expression

[Lash20]

to Mc[X]? (e.g. convert Mcgovern to McGovern, Mcdonald to McDonald) in Oracle (or just SQL code)? I tried using the regexp_replace function in Oracle, but can't quite figure out how to upper case the third character. Thanks

[Lash20]

Though not elegant, I was able to do the following:

select regexp_replace(d_name,'Mc[a-z]', 'Mc' || upper(substr(d_name, 3, 1))) n from
(
select 'Mcfix' d_name from dual
);

Thanks