>I will give that a try.
>
>So no ";" is required?

I did this on SQL server where it isn't - your Oracle may require it.

Just try it couple of ways and see which one works. Try with the simplest

select * from table1

select * from table2

and see what you get. Haven't played with Oracle.