Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UPDATE with RETURNING clause

SozyJul 1 2010 — edited Jul 1 2010
Hello

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2010
Added on Jul 1 2010
5 comments
1,642 views