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: 65144
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: Extract date from string
Next Topic: Error "ORA-00904" while using subquery.
Goto Forum:

Current Time: Sun Aug 20 08:49:29 CDT 2017

Total time taken to generate the page: 0.08214 seconds