首页 > 代码库 > oracle 游标使用(隐式游标)

oracle 游标使用(隐式游标)

1.(隐式游标)从学生表里面查询xing_ming为1的找到就打印 

the Policy is updated successfully.
否则打印
the policy is updated failed.
Set Serveroutput on;     begin      update xuesheng set shu_xue = 1 where xing_ming = 1;              if SQL%Found then         dbms_output.put_line(the Policy is updated successfully.);          commit;       else        dbms_output.put_line(the policy is updated failed.);       end if;     end;  /