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;
Solutions Architect | Umbraco Certified Master | Umbraco MVPx4 | Certified ScrumMaster
"Anyone can cook, but only the fearless can be great." Ratatouille
Comments
Post a Comment