Re: 1 select statment take data from several remotes databses ?

I'm not sure what you're asking for, but if you have simalar tables on different databases and want to union their contents you can make database links to them. See for the correct syntax in the sql handbook (create database link remote_database ..........). The sql looks then:

select * from scott.emp
union all
select * from scott.emp_at_remote_database

Ton

zohar wrote:

> hi there :
>
> how can i make a simple select statment, and retrive data from several
> remote databases
>
> thanks zohar
Received on Sun Oct 24 1999 - 13:58:47 CDT