PL/SQL Updating a Table by using Cursor

declare
  cursor veteriner_cur
  is
  select id
  from mzb_veteriner_bilgileri
  order by id;
begin
  for c1
  in veteriner_cur
  loop
  dbms_output.put_line(
    c1.id
  );
  update mzb_veteriner_bilgileri
  set gorev_baslangic_tarihi=sysdate
  where id=c1.id;
  end loop;
end;

Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Getting Umbraco Content - IPublishedContent vs IContent vs Node vs Document