实现二维表
create or replace function getGoodsMsgForProtocol( str_in in varchar2,str_classId in varchar2)--分类字 return varchar2is str_list varchar2(4000) default 'null';--连接后字符串 str_int number(2) default 0;begin for x in ( select goods.goodsname,goods.specs from t_Goods goods where goods.id=str_in) loop str_list :=x.goodsname||'='||x.specs||' '; str_int:=+1; end loop; if str_list='null' and str_int=0 then for x in ( select goodshistory.goodsname,goodshistory.specs from t_Goodshistory goodshistory where goodshistory.goodsid=str_in) loop str_list :=x.goodsname||'='||x.specs||' '; str_int:=+1; end loop; end if; if str_list='null' and str_int=0 then for x in ( select ac.acname,ac.specs from t_accessory ac where ac.id=str_in) loop str_list :=x.acname||'='||x.specs||' '; str_int:=+1; end loop; end if; if str_list='null' and str_int=0 then for x in ( select ach.acname,ach.specs from t_accessoryhistory ach where ach.id=str_in) loop str_list :=x.acname||'='||x.specs||' '; str_int:=+1; end loop; end if; if str_list='null' and str_int=0 then for x in ( select gs.goodsclassname from t_goodsclass gs where gs.id=str_classId) loop str_list :=x.goodsclassname||'='||' '; str_int:=+1; end loop; end if; return str_list;end;
