[PLSQL] For sql pl sql how to use for statement
[PLSQL] For sql pl sql how to use for statement
------------------------------------------------------------------------------------------------------
declare
deger number :=1;
begin
for i in(select * from tableName where kosul)
loop
update tableName set col1=deger where kosul1 = i.kosul1 and kosul2 = i.kosul2;
commit;
end loop;
end;
---------------------------------------------------------------------------------------------------------
Yorumlar
Yorum Gönder