Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in Oracle only
Search
Advanced Search
Forums
Product Launch
Updates
Today's Posts
Member List
Calendar
Home
Forum
Topic
Oracle
Accessing two Databases using a single SQL query
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
Ikamar
New Member
Join Date:
Nov 2011
Posts:
2
#1
Accessing two Databases using a single SQL query
Nov 26 '11, 12:19 PM
Does anyone know of an SQL statement that combines data directly from two different databases?
rski
Recognized Expert
Contributor
Join Date:
Dec 2006
Posts:
700
#2
Nov 26 '11, 05:26 PM
You have to use dblink for access remote dtabase.
See here
CREATE DATABASE LINK
http://docs.oracle.com/cd/B14117_01/server.101/b10759/statements_5005.htm
Comment
Post
Cancel
Ikamar
New Member
Join Date:
Nov 2011
Posts:
2
#3
Nov 28 '11, 05:21 AM
Thanks rski. I'm currently trying it out.
Comment
Post
Cancel
Previous
template
Next
Working...
Yes
No
OK
OK
Cancel
👍
👎
☕
Comment