废话不多说,直接上代码
create or replace function f_get_idcard_address(p_idcode in varchar2)
/*
Create By yuxiao
2018-04-27
*/
return varchar is
v_area varchar2(50);
begin
select area
into v_area
from yuxiao.idcard
where idcode = substr(p_idcode, 1, 6);
return v_area;
exception
when others then
return null;
end f_get_idcard_address;
create or replace function f_get_idcard_birthday(p_birthday in varchar2)
/*
Create By yuxiao
2018-04-27
*/
return varchar is
begin
return to_char(to_date(substr(p_birthday, 7, 8), 'yyyymmdd'),
'yyyy"年"mm"月"dd"日"');
exception
when others then
return null;
end f_get_idcard_birthday;
create or replace function f_get_idcard_sex(p_sex in varchar2)
/*
Create By yuxiao
2018-04-27
*/
return varchar is
begin
return cas