SQL Developer


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

Related Links

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?
popup describe
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

Categories

ORACLE DEV
General Database Discu...
XML
Database Upgrade
Oracle Call Interface ...
Heterogeneous Connecti...
Integration and Events
Financial Services
Communications and Media
Database Archived Forums
Personalization
Instant Client
SyncML
Email Server
Workspaces
Integration - Adapters
RDF Semantic Graph
Technical Bulletin (Ko...
Technologies - JSP (Ko...
Installation>MS Window...
LCM: R12 Install/Upgrade
Business Intelligence ...
Siebel Archived Forums
MDM Integration and Bu...
CRM On Demand Analytic...
CRM On Demand Administ...
Identity Management Ar...
BPA Suite (Korean)
WebLogic Server/Java E...
AquaLogic User Interac...
I(18)N & Localization
aqualogic.bpm.runtime
Portlets
Construction and Engin...
ADF UI Patterns & Best...
EJB Development (Chinese)
SOA & Web Services (Ch...
行业专区
LCM: Oracle Applicatio...
ORDS, SODA & JSON in t...
JavaFX 1.x and JavaFX ...
Conventional & Interru...
Solaris Zones
Java Virtual Machine (...
Java Desktop Applications
Signed Applets
Solaris on x86
Java Game Development
JavaMail
Java EE SDK
Java System Message Queue
Event Handling
Socket Programming
Web Space Server
Java Enterprise System...
ミドルウェア
Oracle Database 11g Ex...
Oracle University Deli...
Information Discovery
Siebel (Chinese)
JD Edwards EnterpriseO...
Governance, Risk & Com...
Oracle Tuxedo (Japanese)
JD Edwards (Chinese)
Daily Notifications
Oracle Mobile
My Oracle Support Sear...
Architecture - General...
Engineered Systems
Portuguese
General Database Discu...
Social Media Hub
Houston TX Eloqua Users
Eloqua User Group - Ba...
EMEA Eloqua Users
United Kingdom User Group
Eloqua Users with MS C...
Eastern Canada Eloqua ...
Non-profits and Member...
Modern Marketing Exper...
Oracle Marketing Cloud...
BICS Data Visualization
El Salvador
See How
Oracle x86 Servers
SouJava Campinas JUG
Optimized Solutions
Oracle EMEA Partner Sales
Korea Engineered Syste...
All China Oracle User ...
Bare Metal Cloud Servi...
North Central Oracle A...
Tajikistan Oracle User...
JDeveloper and ADF
General XML
Generic Linux
Financials
Business Intelligence ...
Identity Manager
产品
Oracle VM Server for x86
Archived Newsgroups
Primavera Risk Analysi...
WebLogic开发
Java Programming
Patterns & OO Design
Systems Management Bes...
Oracle HCM Cloud Service
Middleware Track
DB Design Award Winner...

Resources

Encrypt Message