DECLARE
NO_OF_ROWS_A NUMBER := 0;
NO_OF_ROWS_E NUMBER := 0;
BEGIN
FOR OBJ IN (select status from table1)
LOOP
if(condition) THEN
UPDATE table2 SET status=1 WHERE condition;
NO_OF_ROWS_A = NO_OF_ROWS_A 1;
END IF;
END LOOP;
END
我在“ NO_OF_ROWS_A = NO_OF_ROWS_A 1;”處收到錯誤
誰能告訴我出了什么問題？
uj5u.com熱心網友回復：
違規陳述應該是
NO_OF_ROWS_A := NO_OF_ROWS_A 1;
^
|
this
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/461916.html
上一篇：OracleSQL觸發器未創建