createorreplacefunction'fn_getaddress'(v_id number)return varchar2
is
v_name varchar2(30);beginselect name into v_name from't_address'where id=v_id;return v_name;end;
测试此函数。
select fn_getaddress(3)from dual;
需求:查询 业主ID,业主名称,业主地址,业主地址,使用存储函数来实现。
select id '编号', name '业主名称', fn_getaddress(addressid)'地址'from t_owners;