Kayıtlar

Aralık, 2017 tarihine ait yayınlar gösteriliyor

[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; ---------------------------------------------------------------------------------------------------------