commit after n rows while update
anup13Jul 28 2009 — edited Jul 29 2009i have 1 update query
UPDATE security
SET display_security_alias = CONCAT ('BAD_ALIAS_', display_security_alias)
WHERE security_id IN (
SELECT DISTINCT security_id
FROM security_xref
WHERE security_alias_type IN ('BADSYMBOL', 'ERRORSYMBOL', 'BADCUSIP', 'ERRORCUSIP' )
);
i want to perform commit after every 500rows ( due to Business requirement) how can we achieve this. please help