sql 中 sql%rowcount 判断执行SQL受影响的行数

最新推荐文章于 2024-09-03 16:28:30 发布

最新推荐文章于 2024-09-03 16:28:30 发布 · 449 阅读

文章标签：

#SQL

本文通过一个具体的更新语句示例介绍了如何使用SQL中的%ROWCOUNT来判断执行SQL语句受影响的行数。当更新语句影响的行数超过1时，将引发特定错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

sql 中 sql%rowcount 判断执行SQL受影响的行数

例子：
update work_order
set order_state = '1'
where line_id = p_line_id
and order_state = '0'
and order_type = 'DPY'
and ORDER_PRIORITY = (select min(ORDER_PRIORITY)
from work_order
where order_state = '0'
and order_type = 'DPY'
and LINE_ID = p_line_id
and order_priority > 0
group by LINE_ID)
and exists
(select 1
from product_level pl
where pl.pid = pid
and pl.child_pid =
(select (select pid
from product_maintain pm
where pm.product_number =
rw.material_number
and pm.rstate = rw.material_rstate)
from routing_wip rw
where rw.sn = p_sn))
and rownum <= 1;

if sql%rowcount > 1 then [color=red] //代表上面update语句影响的行数[/color]

raise_application_error (-20015,
'Work order with same priority in the waiting queue ! ');

end if ;