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 --這樣會(huì)報(bào)錯(cuò) 求指教該如何寫
1 回答
慕少森
TA貢獻(xiàn)2019條經(jīng)驗(yàn) 獲得超9個(gè)贊
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; 給個(gè)簡(jiǎn)單的例子作為參考
- 1 回答
- 0 關(guān)注
- 951 瀏覽
添加回答
舉報(bào)
0/150
提交
取消