-- Oracle

SELECT SQL%ROWCOUNT FROM DUAL;

-- Postgres 1
GET DIAGNOSTICS int_var = ROW_COUNT;

-- Postgres 2
WITH rows AS (
  INSERT | UPDATE
)
SELECT COUNT(1) FROM rows;