Title / Description
Code declare noM number; noS number; V_count integer := 1; cursor cur is select ts.NOMOR_MAHASISWA, sek.NOMOR from siska.TEMP_SEKOLAH ts join siska.SEKOLAH sek on ts.SMU = sek.NAMA_SEKOLAH; begin open cur; loop fetch cur into noM, noS; exit when cur%NOTFOUND; update siska.GABUNGAN set nomor_sekolah = nos where nomor_mahasiswa = noM; end loop; commit; close cur; end;
Author
Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code