我正在尝试从tableA循环所有记录,并为columnA = 1和记录的后半部分设置一半记录columnA = 2。
宣布
类型T2是表格的表格%行类型索引由……
Select * Bulk Collect Into V2 From TableA Where Rownum < Mhalf; Select * Bulk Collect Into V3 From TableA Where Rownum >= Mhalf;
改成:
SELECT * BULK COLLECT INTO V2 FROM ( SELECT a.*, ROWNUM rn FROM ( SELECT * FROM tablea ) a ) WHERE rn < Mhalf; SELECT * BULK COLLECT INTO V# FROM ( SELECT a.*, ROWNUM rn FROM ( SELECT * FROM tablea ) a ) WHERE rn >= Mhalf;