> Is it possible to do cross database (multi-dababase) connection and
> query?
>
> Can someone explain how to connect and do a multiple database query?
> I need to select information from one database to insert into another.
>
> example:
>
> SELECT EMPNO FROM Database1:TABLE_EMP, Database2:TABLE_EMPNAMES
> WHERE ...

Single transaction can span several databases (two-phase commit it then used).
Single command can be execute in one of those databases only.

i.e. you can (inside one transaction) select from one database
and insert into another database (using two separate commands),
but you can't do the same using single command like
insert into db1.tab select id from db2.tab;

Ivan