Kako da utvrdim koliko je redova promenjeno pomocu UPDATE naredbe (koja se poziva iz PL/SQL procedure)? U SQL referecnce manualu sam video ovaj primer ali mi to ne izgleda kao elegantno resenje (u mom slucaju ce takodje biti UPDATE-ovan maksimalno jedan red, mada bi mi resenje za proizvoljan broj redova vise odgovaralo).
Using the RETURNING Clause During UPDATE: Example
The following example returns values from the updated row and stores the result in PL/SQL variables bnd1, bnd2, bnd3:
UPDATE employees
SET job_id ='SA_MAN', salary = salary + 1000, department_id = 140
WHERE last_name = 'Jones'
RETURNING salary*0.25, last_name, department_id
INTO :bnd1, :bnd2, :bnd3;
Citat:
Using the RETURNING Clause During UPDATE: Example
The following example returns values from the updated row and stores the result in PL/SQL variables bnd1, bnd2, bnd3:
UPDATE employees
SET job_id ='SA_MAN', salary = salary + 1000, department_id = 140
WHERE last_name = 'Jones'
RETURNING salary*0.25, last_name, department_id
INTO :bnd1, :bnd2, :bnd3;
Potpis
Owl