1 Reply Latest reply on Jun 1, 2016 2:44 AM by rp0428

    Need help regarding concat

    Jamezy

      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))

      ;

        • 1. Re: Need help regarding concat

          This forum is ONLY for Sql Developer questions/issues. Unless you can connect this to sql dev somehow then please mark the thread ANSWERED and repost it in the Sql and Pl/Sql forum.

          SQL & PL/SQL

           

           

          I've been having a problem when trying to create this dimension for a data cube. I assume it is because of the concatination.

           

          I don't see any 'problem'.

           

          Oracle always raises an exception if it has a problem. So when you repost you need to SHOW US (not just tell us):

           

          1. WHAT you do

          2. HOW you do it

          3. WHAT results you get

          4. WHAT results you expected to get