oracle中for循环配合动态sql,oralce中for执⾏动态sql --oralce中 for 执⾏动态sql
CREATE OR REPLACE FUNCTION fun_checkguaranteetype(TranId varchar2)
return varchar2 is V_result varchar2(1000);
Begin
避孕套用法declare
zhiyavar NUMBER;
diyavar NUMBER;
dabaoren NUMBER;
v_sql varchar2(1000);
--定义type
面试宝典TYPE accountno_type IS TABLE OF actaccount.accountno%TYPE INDEX BY BINARY_INTEGER;
TYPE id_type IS TABLE OF bizpawn.id%TYPE INDEX BY BINARY_INTEGER;
--集合列
accountno accountno_type;左派
id id_type;
begin
v_sql :='lect p1.accountno accountno ,pawn.id dencemode nocredencemode from bizpawn pawn,(';
v_sql :=v_sql||' lationaccountid,act.accountno from actaccount act where act.id in';
v_sql :=v_sql||'(lect trans.accountid from acttransaction trans where trans.id in ('||TranId||')) ) p1 ';
众口铄金
v_sql :=v_sql||'where pawn.lationaccountid';
--执⾏动态sql
EXECUTE IMMEDIATE v_sql BULK COLLECT into accountno,id;
--for
for V1 IN 1 .. accountno.COUNT LOOP
主题班会设计方案--获取值大年初一吃饺子
印鉴管理制度
dbms_output('accountno:'||accountno(v1)||'---id:'||id(v1));
END LOOP;
return (V_result);
end;恐龙简笔画图片大全
end fun_checkguaranteetype;
