Need help regarding concat
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 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 and 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 do2. HOW you do it3. WHAT results you get4. WHAT results you expected to get
sql server migraqtion - nvarchar[max]
Troubles editing tables with partitions
how to export/import database from tools menu in sql developer.
sqldeveloper 1.5.3 caching stored proc?
SQL developer data modelling (Access table in db ?)
Create Oracle DataBase in VC++ using oledb
Happy New Year 2009
Question about Source Version Control
How to get the script of a table or view in SQL Developer?
BLOB and CHECK constraint
Can we group conncetions/ connection tabs by colours
Data Model: generation questions
Check for updates doesn't report core updates?
only outline for sqldeveloper on ubuntu 8.10 is visible
sql data modeller: Data Dictionary