Data wordt ingelezen uit een Excel-werkboek via onderstaande SQL. De named range “brandspecific” loopt van $A$1 tot $K$165.
De dertiende kolomdefinitie extra_value_speciaal_brand
had een foutmelding m.i. moeten geven omdat de named range maar twaalf kolommen bevat.
create or replace table branddeviations@inmemorystorage
as
select *
from exceltable
( name 'brandspecific'
passing file '${FILE_NAME_PATH_EXTEND_ORIG}'
skip first 1 rows
columns code varchar2 position next
, extra_value_code_orig varchar2 position next
, extra_value_brand_postfix varchar2 position next
, description varchar2 position next
, itemgroupcode varchar2 position next
, PRICE number position next
, price_combined number position next
, price_general_labor number position next
, price_brand_labor number position next
, extra_value_inbouw integer position next
, extra_value_inbouw_brand integer position next
, extra_value_speciaal integer position next
, extra_value_speciaal_brand integer position next
)
where ( extra_value_inbouw_brand is not null or extra_value_speciaal_brand is not null )