CREATE OR REPLACE FUNCTION F_GET(STR VARCHAR2)
RETURN VARCHAR2
IS
得使用LENGTHB(‘$abcd$efghij$kfgfdsgr$gfdgd$dsrere$rtr’)然后 if INSTR(STR,'$',1) > 0 then
replace(STR,..函数替换
RETURN VARCHAR2
IS
得使用LENGTHB(‘$abcd$efghij$kfgfdsgr$gfdgd$dsrere$rtr’)然后 if INSTR(STR,'$',1) > 0 then
replace(STR,..函数替换
return varchar2
as
ret_str varchar2(100);
begin
if instr(p_str,'$',1,start_bit)>0 and instr(p_str,'$',1,end_bit)>0 then
ret_str:=substr(p_str,instr(p_str,'$',1,start_bit)+1,instr(p_str,'$',1,end_bit)-1);
return ret_str;
end if;
return '0';
end;
/