Skip to Main Content

Oracle Database Discussions

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!

How: multiple insert stmt's in Database Express edition SQL commands GUI?

547095Nov 20 2006 — edited Nov 20 2006
I have installed the Express 10g version today and played around with it for a while.

If I go to the SQL commands GUI and enter one insert like this:

INSERT INTO pageit (PagID, PagParent, PagName, PagActive) VALUES (19, 17, 'Mango tree', 1)

then it works nicely:

But if I do this:

INSERT INTO pageit (PagID, PagParent, PagName, PagActive) VALUES (20, 17, 'Grape trees', 1);
INSERT INTO pageit (PagID, PagParent, PagName, PagActive) VALUES (21, 16, 'Animals', 1);

Then it says:

ORA-00911: invalid character

Looks like semicolon is not allowed,
but if I remove the semicolon then it says;
ORA-00905: missing keyword

Is there a way to use multiple insert statements in one go in this GUI at all?

If not, could someone please recommend how I do this.

I have exported thousands of insert lines from MySql and I would like to get them into my newly created Oracle table without having to type one line at the time in this gui.

Any suggestions?

Then if there is a nice WEB GUI like phpmyadmin for Oracle then I would like to know about that to? (Preferably free)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2006
Added on Nov 20 2006
4 comments
428 views