Home » SQL & PL/SQL » SQL & PL/SQL » How to run query between 2 schemas (Oracle 10g)
How to run query between 2 schemas [message #574256] Tue, 08 January 2013 04:44 Go to next message
Messages: 29
Registered: August 2011
Location: CA
Junior Member

Is there any way to run a select command between 2 different schemas without using DB links ?

Re: How to run query between 2 schemas [message #574258 is a reply to message #574256] Tue, 08 January 2013 04:58 Go to previous message
Michel Cadot
Messages: 64961
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes if they are in the same database, just qualify the object name by the schema name.

Previous Topic: Partitioned table information
Next Topic: why does SELECT DISTINCT return different rows when used with ORDER BY?
Goto Forum:

Current Time: Tue Jun 27 16:02:16 CDT 2017

Total time taken to generate the page: 0.10776 seconds