oracle11g - Is it possible to query off a Sybase table and join with an Oracle dimension table? -


is possible?

select s.*, o.* sybaseserver.database.schema.table s  left join oracleserver.schema.table o on s.syabseid = o.oracleid 

you can install oracle transparent gateway allow oracle query use db link towards sybase ase server.


Comments

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

Python Tornado package error when running server -

Qt QGraphicsScene is not accessable from QGraphicsView (on Qt 5.6.1) -