UPDATE with RETURNING clause
SozyJul 1 2010 — edited Jul 1 2010Hello
It's possible to return a single-set aggregate function in the expression of the returning clause:
UPDATE employees
SET salary = salary * 1.1
WHERE department_id = 100
RETURNING SUM(salary) INTO :bnd1;
Is it possible to return other aggregate function like RETURNING DISTINCT(salary) in 10g R2 ?
Appreciate all responses.
Thanks
Sozy