PL/SQL Insert Data Using Max Function


declare
  v_max_id number;
begin
  select max(region_id)
  into v_max_id
  from regions;
  dbms_output.put_line(v_max_id);
  insert into regions
  (region_id,region_name)
  values(v_max_id+1,'Australia');
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