oracle to sql server query

Toad Data Point
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!