Пример скрипта создания метки документа : Супермаг Плюс (Супермаг 2000)

declare 
 sLabelID supermag.SMCustomLabels.ID%type := 'Alco.ExcludeDoc';
begin
 insert into supermag.SMCustomLabels (ID, Name, ValueType, Preset, LimitChoice)
   select sLabelID, 'Не включать в алкогольную декларацию', 1, '0', '0' from dual
  where not exists (select 1 from supermag.SMCustomLabels where ID=sLabelID);
 insert into supermag.SMDocLabels (DocType, LabelID) select 'WI', sLabelID from dual
  where not exists (select 1 from supermag.SMDocLabels where DocType='WI' and LabelID=sLabelID);
 insert into supermag.SMDocLabels (DocType, LabelID) select 'WO', sLabelID from dual
  where not exists (select 1 from supermag.SMDocLabels where DocType='WO' and LabelID=sLabelID);
 insert into supermag.SMDocLabels (DocType, LabelID) select 'IW', sLabelID from dual
  where not exists (select 1 from supermag.SMDocLabels where DocType='IW' and LabelID=sLabelID);
end;
/