troubleshooting Question

ORACLE SQL DEVELOPER reports error

Avatar of czechmate1976
czechmate1976Flag for United Kingdom of Great Britain and Northern Ireland asked on
DatabasesOracle DatabaseSQL
8 Comments1 Solution290 ViewsLast Modified:
Can anyone help me find an error in this query please, I am trying to insert multiple rows at once but the blimming thing won't let me, saying the SQL command is not properly ended!! I am going mad here. Thanks for saving my sanity.

Please see the example in the code snippet.


INSERT INTO customer(
custid, firstname, lastname, houseno, street, city, postcode, telnum, email, county
) VALUES (
100012, 'Sergio', 'Fish', '34', 'Johny Walker Av', 'Kingston', 'K2 5OP', '02080987456', 'walkerJohn@bt.com', 'surrey' 
) , (
100013, 'Georg', 'Hanz', '12', 'Fishmongers Lane', 'Brighton', 'B2 0YU', '01940123456', 'hanzie@talktalk.co.uk', 'Kent');
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros