Yes - take a look at "OPENQUERY"

OpenQuery is a function that takes two parameters - the database link name and the query against the remote database. It essentially creates a logical table from that data, and then you query that.

select myFirstColumn

,mySecondColumn

from OPENQUERY(LinkedServerName, 'Select shisher as myFirstColumn, shasher as mySecondColumn from myOracleTable')

where myFirstColumn = @myOnlyParameter

These are all nonsense names, of course. I use column aliases in the select statement which is the second parameter to OPENQUERY to demonstrate that it is a logical table being created, and you are then, outside OPENQUERY, selecting from that logical table.

Hope this helps. Please note that this is not exhaustive regarding Openquery. Maybe it has multiple signatures and can take other parameters, too. I don't know. I'm just showing how I use it and how it works for my purpose.

Of course, this rests on the linked server being set up correctly to allow you to get at that data.

HTH