title: Transferring data between MySQL and Oracle databases
body: <p>Here's the scenario:<br>
  I have a MySQL DB, and an Oracle DB, and what I want to do is copy data from MySQL to Oracle, on a scheduled basis.</p>
  
  <p>The process includes just inserting data to a table on the Oracle side, taken from the MySQL db.</p>
  
  <p>Something like this: (oracle command)</p>
  
  <pre><code>insert into my_oracle_table  
  select * from my_mysql_table@my_mysql_db  
  where date &gt; sysdate - 7;
  </code></pre>
  
  <p>What is the best practice for this?  Is there a way to connect say to the MySQL db directly from an Oracle stored procedure? Maybe the other way round?</p>
  
  <p>Oracle 11g and MySql 5.1</p>