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 關注
- 953 瀏覽
添加回答
舉報
0/150
提交
取消