create or replace procedure To_Update() as
begin
update tbname set col1 = 1 where col2 = 2;
commit;
exception
when others then
roll back;
end;
begin
update tbname set col1 = 1 where col2 = 2;
commit;
exception
when others then
roll back;
end;
"column_name"
ON "tablename"
FOR EACH ROW
DECLARE
BEGIN
.....
END;
begin
update table_name set column_name1 = 1 where column_name2 = 2;
commit;
exception
when others then
roll back;
end;
IS
BEGIN
UPDATE TABLE_NAME
SET COL_NAME='SDF';
COMMIT;
END;