Home » SQL & PL/SQL » SQL & PL/SQL » Retrieving data  () 1 Vote
Retrieving data [message #211799] Tue, 02 January 2007 06:14 Go to next message
ykp158
Messages: 1
Registered: November 2006
Junior Member

how to retrieve data using single query statement from more than 1 database in oracle.

Is this possible with oracle?


Re: Retrieving data [message #211800 is a reply to message #211799] Tue, 02 January 2007 06:19 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Database link should be used.
Re: Retrieving data [message #211801 is a reply to message #211799] Tue, 02 January 2007 06:19 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Yes, search this site for "database links" and "create database link".
Re: Retrieving data [message #211805 is a reply to message #211801] Tue, 02 January 2007 06:26 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
./fa/1940/0/
Re: Retrieving data [message #211809 is a reply to message #211805] Tue, 02 January 2007 06:44 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Great timing! 14:19 on the minute Smile
Previous Topic: Query Returning Null Values
Next Topic: Min date value in the future, how can I do it??
Goto Forum:
  


Current Time: Mon Dec 05 20:58:37 CST 2016

Total time taken to generate the page: 0.13424 seconds