CURSOR cur_test IS SELECT city_code,customer_id,first_name from test_table;For rec_cur_test in cur_test loop dbms_output.put_line(cur_test.city_code); dbms_output.put_line(cur_test.customer_id); dbms_output.put_line(cur_test.first_name); end loop;
CURSOR cur_test IS SELECT city_code,customer_id,first_name from test_table;For rec_cur_test in cur_test loop dbms_output.put_line(cur_test.city_code); dbms_output.put_line(cur_test.customer_id); dbms_output.put_line(cur_test.first_name); end loop;红色部分不晓得 也不晓得具体有多少列
SELECT city_code,customer_id,first_name from test_table;For rec_cur_test in cur_test loop
dbms_output.put_line(cur_test.city_code);
dbms_output.put_line(cur_test.customer_id);
dbms_output.put_line(cur_test.first_name);
end loop;
SELECT city_code,customer_id,first_name from test_table;For rec_cur_test in cur_test loop
dbms_output.put_line(cur_test.city_code);
dbms_output.put_line(cur_test.customer_id);
dbms_output.put_line(cur_test.first_name);
end loop;红色部分不晓得 也不晓得具体有多少列