PL/SQL Connect By Prior

select * from test_table_name connect by prior id=root_id start with root_id=211;

declare
  cursor c_birim
  is
  select *
  from test_table_name
  connect by prior id=root_id
  start with root_id=211;
begin
  for r_birim in c_birim loop
      update test_table
      set tur_id=1
      where id=r_birim.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