i have a doubt here that would like to have some advice from u all. Can i get data from Oracle 10g database if i have an application running on MS SQL ? If can, would it be cumbersome afterall? Please advice.
... an application running on MS SQL Server ... ???
Anyway, I get the picture. Yes you can create a connection to the Oracle database and then for instance create a linked server using that (ODBC for example) connection. You can query the data within the Oracle instance from within the ... application running on the MS SQL ...
> SELECT * FROM users WHERE clue > 0;
Empty set (0.00 sec)