Count of MERGE INTO UPDATE

0

Hi, I'm using MERGE INTO with UPDATE on top of ICEBERG. For example MERGE INTO accounts t USING monthly_accounts_update s ON (t.customer = s.customer) WHEN MATCHED THEN UPDATE SET purchases = s.purchases + t.purchases

I would like to know how many records were updated during this query. I see query result doesn't return this number.

Any option to get the number of updated rows?

Thank you

moshe
已提問 5 個月前檢視次數 148 次
沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南