oracle for循环查找结果

-- Call the procedure
begin
for v_rlt in (select * from oqc_inspection_sample s where s.state='A' AND S.status='已检验' and s.is_v2='1' ) loop
dbms_output.put_line('v_rlt = '||v_rlt.ID||v_rlt.inspection_no);
end loop;
dbms_output.put_line('FOR循环已经结束!');
end;

 
原文地址:https://www.cnblogs.com/chenli0513/p/5712510.html