Home » SQL & PL/SQL » SQL & PL/SQL » Select from different database
Select from different database [message #236582] Thu, 10 May 2007 05:22 Go to next message
aadebayo
Messages: 35
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
Re: Select from different database [message #236589 is a reply to message #236582] Thu, 10 May 2007 05:33 Go to previous messageGo to next message
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.
Re: Select from different database [message #236687 is a reply to message #236589] Thu, 10 May 2007 11:15 Go to previous message
Frank
Messages: 7880
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.
Previous Topic: Need Query to simulate ROW_NUMBER
Next Topic: UTL_FILE file handling capacity
Goto Forum:
  


Current Time: Sat Dec 10 04:45:11 CST 2016

Total time taken to generate the page: 0.07906 seconds