OraFAQ Forum: SQL & PL/SQL » doing a select on multiple databases in a single query

Home » SQL & PL/SQL » SQL & PL/SQL » doing a select on multiple databases in a single query

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

doing a select on multiple databases in a single query [message #358862]

Wed, 12 November 2008 14:18

ramy
Messages: 3
Registered: November 2008

Junior Member

Hi,
I want to do a select on 2 databases(both oracle) in a single query and obtain the columns from both.
How to do this..as each db has its own credentials..i can't do something like db1.table1.column1 and db2.table1.column1.
Any help is appreciated.

Thanks
R

Report message to a moderator

Re: doing a select on multiple databases in a single query [message #358865 is a reply to message #358862]

Wed, 12 November 2008 14:34

joicejohn
Messages: 327
Registered: March 2008
Location: India

Senior Member

@ramy,

One way of acheiving this is via a DATABASE LINK

Hope this helps.

Regards,
Jo

Report message to a moderator

Re: doing a select on multiple databases in a single query [message #358870 is a reply to message #358862]

Wed, 12 November 2008 15:11

ramy
Messages: 3
Registered: November 2008

Junior Member

Thanks for the reply..currently i have only select priviliges on the tables of both the dbs.So is it possible to do a database link between the current and remote databases.

When i do a select global_name from global_name; it shows only my current database service name.
Or do i need additional priviliges.

Report message to a moderator