contiunally getting ORA-00907: missing right parenthesis error when trying to insert data in my star scheme using the code:
INSERT INTO account_dim (account_id, account_name) SELECT (acc_seq.nextval, lds_account.acc_name) FROM lds_account;
INSERT INTO account_dim (account_id, acount_name) SELECT (acc_seq.nextval, mch_account.acc_name) FROM mch_account;
Can anyone make any suggestions?
Seems there was a bug years ago ( http://www.dba-oracle.com/sf_ora_00907_missing_right_parenthesis.htm ) so there's that and you need to print/debug those variables to see if it's clean.
Well you 2nd insert your column names, specifically this "acount_name" looks different then the 1st where it's "account_name" (notice the extra c). I don't know if that might be causing some issues or if it was just a typo when you wrote this post
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.