We have Oracle Client installed in lot of our SQL Servers for Linked Servers.
I can go to each SQL Server and check the Oracle Client version by running SQLPLUS or check under Providers for Linked Servers if OraOleDB.Oracle exists.
There are more than 200 SQL Servers so the process is very tedious if done manually for each server.
Iis there some query like @@version etc to find the Oracle Client Version ? Then I can put in a vbscript and run it across a list of SQL Servers.