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
abhayman
Messages: 12
Registered: August 2011
Location: CA
Junior Member
Hi,

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

Regards,
Abhay
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: 58542
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.

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


Current Time: Thu Jul 24 15:05:30 CDT 2014

Total time taken to generate the page: 0.12682 seconds