Multi-Session Select? - Allround Automations forums

Register Log In

Forums Products Direct Oracle Access Multi-Session Select?

Print Thread

Multi-Session Select? #2014 05/14/01 08:47 PM
Joined: May 2001 Posts: 3 Cambridge,Cambridgeshire,UK T timbo OP Member
OP timbo Member T Joined: May 2001 Posts: 3 Cambridge,Cambridgeshire,UK	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

Re: Multi-Session Select? #2015 05/17/01 04:52 PM
Joined: Aug 1999 Posts: 22,217 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,217	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 Marco Kalter Allround Automations

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.030s Queries: 12 (0.007s) Memory: 2.4980 MB (Peak: 3.0421 MB) Data Comp: Off Server Time: 2024-05-14 07:59:28 UTC
Valid HTML 5 and Valid CSS