create or replace function njutec_toexgehextointcolor(strcolor in varchar2) return varchar2 is
Result varchar2(4000);
str1 varchar2(200);
str2 varchar2(200);
str3 varchar2(200);
begin
Result:='';
str1:='';
str2:='';
str3:='';
if (strcolor is null) then
select to_number(substr('#f1f4f5',2,2),'xx') into str1 from dual;
select to_number(substr('#f1f4f5',4,2),'xx') into str2 from dual;
select to_number(substr('#f1f4f5',6,2),'xx') into str3 from dual;
Result:='RGB('||str1||','||str2||','||str3||')';
else
select to_number(substr(strcolor,2,2),'xx') into str1 from dual;
select to_number(substr(strcolor,4,2),'xx') into str2 from dual;
select to_number(substr(strcolor,6,2),'xx') into str3 from dual;
Result:='RGB('||str1||','||str2||','||str3||')';
end if;
return Result;
end njutec_toexgehextointcolor;