I have never claimed, that I am an expert, but
I will try to answer anyway.
What you need is a DATABASE LINK. The idea is
that you with some restrictions can reference
a remote table, e.g. test_at_AUDV, just as if it
were a local table.
I have made a quick and dirty test:
On remote database
drop table test;
create table test
insert into test values
('This is remote data');
On local database
create database link AUDV
connect to jhn
identified by remotepass
create table localtab
insert into localtab values
('This is local data');
set c =3D (select c
I hope this gives you an idea of
how it is working.
Jesper Haure Norrevang
Fra: oracle-l-bounce_at_freelists.org =
vegne af Goodson, Doris
Sendt: 11. januar 2005 02:38
Emne: Need SQL to connect remotely
I was wondering if any SQL experts are on the list.
I need to update a field in my current database with a field from =
Any ideas how to do this through sql worksheet session?