oracle - Number of rows affected by SQL statement using Aqua Data Studio -


i running 30 separate merge statements may or may not update records in 30 tables (1 table per merge statement).

how can see how many rows each individual merge statement affected, using aqua data studio?

i've been trying use sql%rowcount, haven't figured out yet.

enable text results in query window. go file options results > text results , enable options suite needs. 1. display 'records affected' count. 2. display total number of affected records.

enter image description here

enter image description here


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -