Query

Extract the first occuring numbers from the srting

select replace(:string, ltrim(:string, '1234567890')) from dual;

input parameter is 12Abdg345

Count the number of occurence of a letter

select instr('Meeraghee','e') from dual

select :str as "string", :chr as "character", length(:str) - length(translate(:str,chr(0)

:chr,chr(0))) as "count"from dual;
 

replace(:string, ltrim(:string, '1234567890')) from dual;