Re: How to avoid distributed query in PL/SQL???

What you are describing is a replicated environment. Create a local table using snapshots to reflect your remote data. This will allow you to create a query that will use two local tables without a distributed join.

-Sheilah Scheurich
DBA
to respond via email remove "want no spam at all" from my address.

Nagesh Chigurupati wrote:

> Hi everyone,
>
> I am in a situation where I have to write a query in a procedure that
> is join between tables on two
> servers. I basically have to retrieve data on a remote server based on
> values of a column in the
> local database.
>
> Eg:
> Column_values_on_local = '1','2','3','4',.......
>
> Now is there a way to store these in a local variable such as a table
> or record and then use these
> variables in the query for the remote table? This way I could avoid
> writing a distributed join query.
>
> Any response would be greatly appreciated.
>
> Thank you.
>
> Nagesh
Received on Thu Dec 18 1997 - 00:00:00 CST