I have created a linked server to n oracle database which works fine i.e. I can pull data. However I want to insert data into this oracle table depending on rows returned from a SQL 2000 query:
1. select * from my table
2. insert results set into the oracle database table
How do I link these together using insert into openquery?