Hi,
in one of my projects we have used triggers to capture those changes applications made to database tables and then processed them into the tables of another database.
This implies that you will need to set up some transfer and processing tasks on either side.
You may want to limit yourself to only SQL Server and update the Oracle instance from SSIS packages as well.
A lot depends on your specific setuo though.
Michael