for aa in (select * from tb) loop for bb in (select column_name from user_tab_columns where table_name ='tb' order by column_id ) loop v_name:= aa.bb.column_name --这样会报错 求指教该如何写
1 回答
慕少森
TA贡献2019条经验 获得超9个赞
LOOP SAVEPOINT signsavepoint; BEGIN OPEN c_truck; eventkeylist := ''; truckeylist := ''; LOOP FETCH c_truck INTO backtruckkey, backeventlogkey; EXIT WHEN c_truck%NOTFOUND; IF eventkeylist = '' AND truckeylist = '' THEN eventkeylist := '''' || eventkeylist || ''''; truckeylist := '''' || backtruckkey || ''''; ELSE eventkeylist := ',''' || eventkeylist || ''''; truckeylist := ',''' || backtruckkey || ''''; END IF; END LOOP; CLOSE c_truck; END; END LOOP; 给个简单的例子作为参考
- 1 回答
- 0 关注
- 920 浏览
添加回答
举报
0/150
提交
取消