On 16 November 2010 20:09, Hu, William <HuW(at)trimet(dot)org> wrote:
> Hi, I have a need to select some data in a Oracle database from a Postgresql
> table. I know how to do this among Oracle instances, eg. Select * from
> table(at)another_instance(dot)
>
>
>
> Are there similar approach without replicate the database tables?
>
>
>
> Thanks in advance.
Yes. Look at dbi-link.
--
Regards,
Peter Geoghegan