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?

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.