Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INSERT Multi-values from List ??

Kodiak_SeattleOct 21 2008 — edited Oct 22 2008
Having some problems, this seems simple, but it's giving me an error: ORA-00913 too many values

create table CUST_KEYS_08 (CUST_KEY number);

Great that worked!

I have a list from Excel and I simply want to insert all the cust_keys, one after another into this column that I just created, this give me the error:

INSERT INTO CUST_KEYS_08 (CUST_SKEY)
VALUES (1,2,3,4,5,6,blablabla, all numbers);

How can I fix this ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2008
Added on Oct 21 2008
13 comments
1,647 views