Multi-Session Select?

[timbo]

Hi,
I've got two sessions, one connected to the local database and the other connected to a Net8 link over the network. I want to execute a SELECT statement involving two tables, one from each session.
How can I do this? (Doing it in SQL*Plus is easy enough, if you can get database links to work).
thanks,

Timbo

 

[Marco Kalter]

You need to create a database link in your local database to the remote database. This is not different than in SQL*Plus.

------------------
Marco Kalter
Allround Automations