UPDATE using WHERE CURRENT OF clause
I can never remember the syntax on the "FOR UPDATE OF" clause!
Copy this code and paste it in your HTML
/* Search query using cursor, then update selected columns in the searched table(s)
*/
FOR search_rec
IN people_cur
update_count := update_count + 1;
DBMS_OUTPUT.PUT_LINE
('Updated ' || update_count
|| ' addresses.');
Report this snippet
Comments
Subscribe to comments