问题出在李四这个数据上此时id=4,年龄24 不满足条件但循环到这条数据时出错赋值语句:select employee_id, employee_name into e_id, e_name from employees where employee_id = v_id and employee_age>=25;出错也就是说,没有数据的时候是不能用select into 变量这种方式的...
楼上说的没错这种情况一般这么写for i in (select employee_id, employee_name into e_id, e_name from employees where employee_id = v_id and employee_age>=25) loop
dbms_output.put_line('满...