...
declare
iPos integer;
begin
select nvl(max(Position),0) into iPos from SACardPropDef;
iPos := iPos + 1;
insert into SACardPropDef(ID, Name, DataType, Preset, Status, ToCash, Position)
select 'YandexEda.Picture.URL', 'Адрес изображения артикула', 0, '0', '1', '0', iPos
from dual
where not exists (select 1 from SACardPropDef where ID='YandexEda.Picture.URL');
iPos := iPos + 1;
insert into SACardPropDef(ID, Name, DataType, Preset, Status, ToCash, Position)
select 'YandexEda.Picture.Hash', 'Хэш-код изображения артикула', 0, '0', '1', '0', iPos
from dual
where not exists (select 1 from SACardPropDef where ID='YandexEda.Picture.Hash');
end;
/
commit;