Multiple "Insert into" not working
646024Jun 19 2008 — edited Jun 20 2008Hello,
I am using SQL Developer 1.5 and here's the problem: I have this table with columns but no rows so far. I used "Show sql for export" form Excel, so I got something like this:
INSERT INTO "table_name" VALUES (...)
INSERT INTO "table_name" VALUES (...)
INSERT INTO "table_name" VALUES (...)
INSERT INTO "table_name" VALUES (...)
and so on
Back to SQL Dev, when I submit these statements, I get this error:
"SQL command not properly ended. Error at line2".
The error disappears if I add a semi-colon at the end of each statement, but when I run the statements, only the first line is added to the database.
Is the only way adding each one at a time? :o
Any idea, please? I'm so newbie at this :(
Thank you