connecting/extracting from multiple schemas

tostay2003 · Post by **tostay2003** » Sat Apr 15, 2006 11:01 am

Hi there,

I dont have a parallel version with me, but have a doubt regarding it while discussing with my friend.

Can we extract data by using single oracle stage from two different schemas using SQL statements??? Can one stage be used to connect to two schemas?

eg :

select A.id,
A.dat1,
A.dat2,
B.id,
B.dat1

from
schema1 A,
schema2 B

where
A.id=B.id

Can we do this??

Regards

ArndW · Post by **ArndW** » Sat Apr 15, 2006 12:55 pm

If yopu can execute this SQL statement with your query tool, then you can do so in PX as well.

chulett · Post by **chulett** » Sat Apr 15, 2006 1:01 pm

Two schemas in the same instance? Sure. Two instances would require dblinks.