Hi, I am a student at MCAST in Malta.
I've been having a problem when trying to create this dimension for a data cube. I assume it is because of the concatination. Any help would be appreciated. Thanks, James.
INSERT INTO JCAR_DIM_CARS(CAR_ID,caryear, brand_id,model_id, type_value,
rdbms_car_id)
(SELECT dim_seq_car_id.NEXTVAL,
car.caryear,
cb.brand_id,
mo.model_id,
CONCAT(ca.car_id, car.caryear,cb.brand_id, mo.model_id),
car.car_id
FROM JCAR_TBL_carbrands cb
JOIN JCAR_TBL_carmodels mo
ON (cb.brand_id = mo.brand_id)
JOIN JCAR_TBL_cars car
ON (mo.model_id = car.model_id))
This is the error given
Error starting at line : 133 in command -
INSERT INTO JCAR_DIM_CARS(CAR_ID,caryear, brand_id,model_id, type_value,
rdbms_car_id)
(SELECT dim_seq_car_id.NEXTVAL,
car.caryear,
cb.brand_id,
mo.model_id,
CONCAT(ca.car_id, car.caryear,cb.brand_id, mo.model_id),
car.car_id
FROM JCAR_TBL_carbrands cb
JOIN JCAR_TBL_carmodels mo
ON (cb.brand_id = mo.brand_id)
JOIN JCAR_TBL_cars car
ON (mo.model_id = car.model_id))
Error at Command Line : 140 Column : 3
Error report -
SQL Error: ORA-00909: invalid number of arguments
00909. 00000 - "invalid number of arguments"