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

From: -=< a q u a b u b b l e >=- <aquabubble_at_Remove.No.Parma.Ham.Remove.geocities.com>
Date: Sun, 24 Oct 1999 20:57:17 +0100
Message-ID: <7uvobr$9dh$1@neptunium.btinternet.com>

zohar <zohar100_at_inter.net.il> wrote in message news:7uvbk8$nt3$1_at_news2.inter.net.il...
> hi there :
>
> how can i make a simple select statment, and retrive data from several
> remote databases
>
>
> thanks zohar

Do this all the time, but normally to link tables together. Syntax for creating a database link is:

CREATE DATABASE LINK link_name
CONNECT TO user_name
IDENTIFIED BY password
USING 'connect_string';

The only thing that should be in quotes is the connect string. Then obviously you can have a query as such:

SELECT a.fruit_id, b.fruit_name

FROM my_fruits a, their_fruits_at_kiwi
WHERE UPPER(b.fruit_name) LIKE '%TROPICAL%' AND a.fruit_id = b.fruit_id;

Simple as that. Received on Sun Oct 24 1999 - 14:57:17 CDT