Toad World® Forums

oracle to sql server query


#1

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


#2

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

SELECT * FROM tablename@dblinkname;


#3

Thanks, It works!