Split field values using specific character
Using regular expressions is an option:


create table capacity (inputdata varchar2(30));

insert into capacity(inputdata) values('10uF');
insert into capacity(inputdata) values('2K');
insert into capacity(inputdata) values('1.0uF');
insert into capacity(inputdata) values('200UF');

commit;

select regexp_substr(inputdata,'^[0123456789.]*') value,
regexp_replace(inputdata,'^[0123456789.]*','') unit
from capacity
;



here is this example on sqlfiddle
Maybe you should improve the regular expression pattern of the number format

Regular expression functions are described here in the manual   and on the following pages