Home » SQL & PL/SQL » SQL & PL/SQL » How to fetch data from different database using single select statement (Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 )
How to fetch data from different database using single select statement [message #442845] Wed, 10 February 2010 23:50 Go to next message
vibhavari
Messages: 19
Registered: October 2009
Junior Member
I need to fetch data from emp table from 2 databases .
How can i select ?
Re: How to fetch data from different database using single select statement [message #442846 is a reply to message #442845] Wed, 10 February 2010 23:51 Go to previous messageGo to next message
BlackSwan
Messages: 24915
Registered: January 2009
Senior Member
>How can i select ?
SELECT * from EMP, EMP@REMOTE

[Updated on: Wed, 10 February 2010 23:52]

Report message to a moderator

Re: How to fetch data from different database using single select statement [message #442847 is a reply to message #442845] Wed, 10 February 2010 23:56 Go to previous messageGo to next message
vibhavari
Messages: 19
Registered: October 2009
Junior Member
emp@remote =>remote is db link or instance name?
Could ypu please help me out ?
Re: How to fetch data from different database using single select statement [message #442850 is a reply to message #442847] Thu, 11 February 2010 00:03 Go to previous messageGo to next message
BlackSwan
Messages: 24915
Registered: January 2009
Senior Member
>Could ypu please help me out ?
It is valid SQL
Re: How to fetch data from different database using single select statement [message #442855 is a reply to message #442847] Thu, 11 February 2010 00:26 Go to previous message
Michel Cadot
Messages: 63817
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
vibhavari wrote on Thu, 11 February 2010 06:56
emp@remote[/email] =>remote is db link or instance name?
Could ypu please help me out ?

SELECT query_table_expression

Regards
Michel

Previous Topic: which execution sequence is maintained in where clause condition ?
Next Topic: Semi Join Issue
Goto Forum:
  


Current Time: Fri Sep 30 17:28:25 CDT 2016

Total time taken to generate the page: 0.27950 seconds