在游标后用for update nowait 锁表,但提示错误。
CURSOR Csr01 IS
select sum(num1)
from aaa
where b='1'
group by
a
for update nowait;
去掉sum就好用了,但我还想保留sum,该如何解决?还请赐教。
CURSOR Csr01 IS
select sum(num1)
from aaa
where b='1'
group by
a
for update nowait;
去掉sum就好用了,但我还想保留sum,该如何解决?还请赐教。
用在这里应该没有意义,舍去就应该可以了!