OraFAQ Forum: SQL & PL/SQL » How to fetch data from different database using single select statement

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 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to fetch data from different database using single select statement [message #442845]

Wed, 10 February 2010 23:50

vibhavari
Messages: 20
Registered: October 2009

Junior Member

I need to fetch data from emp table from 2 databases .
How can i select ?

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

vibhavari
Messages: 20
Registered: October 2009

Junior Member

emp@remote =>remote is db link or instance name?
Could ypu please help me out ?

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Could ypu please help me out ?
It is valid SQL

Report message to a moderator

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

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 13 19:52:03 CDT 2025