Oracle Database Express Edition (XE)

Hi guys,

I have just installed Oracle 10g Express Edition and I was kind of excited to find it so user friendly.

However, there's one thing that makes my life really complicated. I can't run multiple SQL statements at a time.

For example, I've got quite a lot of queries in notepad documents, and I would like to copy and paste them into the command box and then click run, but I always get errors.

It works fine if I run every query one after another, but this is really killing me.

Is there a way of running more than one statement a a time?

Regards,

Aleen