Toad World® Forums

oracle to sql server query


need syntax to query from oracle to sql server. have database link ‘sqlsvr’

select * from [CORP\pzhu].grosstest@sqlsvr

error message is table does not exist.

please help with syntax


If you already have the Oracle link set up to SQLServer then use the Syntax below.

SELECT * FROM tablename@dblinkname;


Thanks, It works!