Livesql Keeps Showing Me This: Ora-00933: Sql Command Not Properly Ended

INSERT INTO Countries (Country, Capital, Cities) VALUES ('Philippines','Manila',122), ('USA','Washington',19495), ('Brazil','Brasilia',1642), ('Latvia','Riga',9), (

Solution 1:

Oracle doesn't support inserting multiple rows using a single values. I find that the simplest method is insert . . . select:

INSERT INTO Countries (Country, Capital, Cities)
    SELECT 'Philippines', 'Manila', 122 FROM DUAL UNION ALL
    SELECT 'USA', 'Washington', 19495 FROM DUAL UNION ALL
    SELECT 'Brazil', 'Brasilia', 1642 FROM DUAL UNION ALL
    SELECT 'Latvia', 'Riga', 9 FROM DUAL UNION ALL
    SELECT 'Egypt', 'Cairo', 124 FROM DUAL;