-- ------------------------------------------------ LOADING OF DATA: load_refer
--                                                                1999.04.22 ft
--
update LOAD_REFER set ref_type_descr='*not filled' where ref_type_descr is NULL;
update LOAD_REFER set citation_id   = 0            where citation_id    is NULL;
--
insert into REFERENCE (entry_id, citation_id,          ref_type_id)
   select              entry_id, citation_id, REF_TYPE.ref_type_id
     from LOAD_REFER, REF_TYPE
    where LOAD_REFER.ref_type_descr = REF_TYPE.ref_type_descr
      and LOAD_REFER.citation_id    <> 0;
