create or replace FUNCTION "TELEWEB".fn_psno_addr (p_no varchar2) return varchar2 as
v_return varchar2(200);
begin
begin
SELECT ADDR_1 INTO v_return
FROM TCL_CO_PSNO_C
WHERE PSNO=p_no AND ROWNUM=1; exception when no_data_found then
v_return := '';
end;
return rtrim(v_return);
end;
v_return varchar2(200);
begin
begin
SELECT ADDR_1 INTO v_return
FROM TCL_CO_PSNO_C
WHERE PSNO=p_no AND ROWNUM=1; exception when no_data_found then
v_return := '';
end;
return rtrim(v_return);
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货