OraFAQ Forum: SQL & PL/SQL » How to run query between 2 schemas

Home » SQL & PL/SQL » SQL & PL/SQL » How to run query between 2 schemas (Oracle 10g)

Tue, 08 January 2013 04:44

abhayman
Messages: 10
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

Tue, 08 January 2013 04:58

Michel Cadot
Messages: 54247
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: Sat May 25 15:51:39 CDT 2013

Total time taken to generate the page: 0.75800 seconds