OraFAQ Forum: SQL & PL/SQL » Select from different database

Home » SQL & PL/SQL » SQL & PL/SQL » Select from different database

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

Select from different database [message #236582]

Thu, 10 May 2007 05:22

aadebayo
Messages: 38
Registered: August 2005

Member

Hello

I have two different databases, one is patch and the other is dev. Please can anyone tell me the syntax for selecting from patch, whilst logged into dev?

Ade

Report message to a moderator

Re: Select from different database [message #236589 is a reply to message #236582]

Thu, 10 May 2007 05:33

iamdurai
Messages: 96
Registered: April 2007
Location: Chennai

Member

Give before that your schema name.

Example

Now i am in Scott.

select * from emp;

ok

againg i went Dev

now i want to select scott tables.

select * from sott.table_name;

like this

Regards
Thangam.

Report message to a moderator

Re: Select from different database [message #236687 is a reply to message #236589]

Thu, 10 May 2007 11:15

Frank
Messages: 7901
Registered: March 2000

Senior Member

You describe a way to select from a different schema. The OP asks how to get to another database.
The answer to that is to use database link.

Report message to a moderator

Previous Topic:	Need Query to simulate ROW_NUMBER
Next Topic:	UTL_FILE file handling capacity

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 05:43:10 CST 2024