oracle:
insert into tablename(id,name) values((select nvl(max(id),0)+1 from tablename) ,namevalue);
pg:
insert into tablename(id,name) values((select coalesce(max(id),0)+1 from tablename) ,namevalue);
oracle:
insert into tablename(id,name) values((select nvl(max(id),0)+1 from tablename) ,namevalue);
pg:
insert into tablename(id,name) values((select coalesce(max(id),0)+1 from tablename) ,namevalue);