By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT regexp_substr('H-Henry Grey;CA;UID123;09870;', 'H-([^;]+)', 1, 1, NULL, 1)
FROM dual;
| REGEXP_SUBSTR('H-HENRYGREY;CA;UID123;09870;','H-([^;]+)',1,1,NULL,1) |
|---|
| Henry Grey |