create or replace function F_Base_suggestmtitem_ItemNM(
PropMt varchar2
)
return varchar2
is
Result varchar2(200);
id varchar2(200);
www varchar2(30);
uuu varchar2(30);
a NUMBER(9) ;
begin
Result:='';
id:=PropMt;
a:=1;
WHILE a>0 loop
select instr(id,',',1,1) into a from dual;
select substr(id,1,instr(id,'_',1,1)-1) into www from dual;
select itemnm into uuu from t_Base_suggestmaintainitem
where recid=www;
Result:=Result||','||uuu;
select substr(id,instr(id,',',1,1)+1)
into id
from dual;
end loop;
select substr(Result,instr(Result,',',1,1)+1)
into Result
from dual;
Return Result;
end F_Base_suggestmtitem_ItemNM;
PropMt varchar2
)
return varchar2
is
Result varchar2(200);
id varchar2(200);
www varchar2(30);
uuu varchar2(30);
a NUMBER(9) ;
begin
Result:='';
id:=PropMt;
a:=1;
WHILE a>0 loop
select instr(id,',',1,1) into a from dual;
select substr(id,1,instr(id,'_',1,1)-1) into www from dual;
select itemnm into uuu from t_Base_suggestmaintainitem
where recid=www;
Result:=Result||','||uuu;
select substr(id,instr(id,',',1,1)+1)
into id
from dual;
end loop;
select substr(Result,instr(Result,',',1,1)+1)
into Result
from dual;
Return Result;
end F_Base_suggestmtitem_ItemNM;
還要麻煩大家一下.三個數組(a,a1,a2,a3,......),(b,b1,b2,b3,......)
(ab,ab1,ab2,ab3,......,a1b,a1b2,a1b3,......,a2b,a2b1,a2b2,a2b3,......)
要將這些分開以後插入數據庫.
ab,ab1,ab2,...這些都是數據,與a,a1,b,b1,沒有關係的.
然後將這三數組以這樣的形式insert
insert into table(amt,A,B)values(ab,a,b)
insert into table(amt,A,B)values(a1b,a1,b)