select 产品名称,厂家id from 产品表 group by 产品名称; 然后分别提取生产厂家id进行显示
select distinct 产品名称, (select 生产厂家 from 产品表) 厂家ID from 产品表不好写,你用程序一行一行地把它显示出来算了!
create or replace function get_id(p_name in varchar2) return varchar2 is Result varchar2(100);
cursor rad_cursor(v_name varchar2) is select 厂家ID from table where 产品名称=v_name; --rad_val rad_cursor%ROWTYPE; begin for ral_val in rad_cursor(p_name) loop
Result:=Result || ',' || rad_val.厂家ID; end loop;
return(Result); end get_id; /select 产品名称,get_id(产品名称) from table group by 产品名称;
然后分别提取生产厂家id进行显示
产品名称,
(select 生产厂家 from 产品表) 厂家ID
from 产品表不好写,你用程序一行一行地把它显示出来算了!
Result varchar2(100);
cursor rad_cursor(v_name varchar2) is
select 厂家ID from table
where 产品名称=v_name;
--rad_val rad_cursor%ROWTYPE;
begin for ral_val in rad_cursor(p_name)
loop
Result:=Result || ',' || rad_val.厂家ID;
end loop;
return(Result);
end get_id;
/select 产品名称,get_id(产品名称) from table group by 产品名称;