MySQLConverter is a project mainly written in Java, it's free.

Java project which Converts MySQL SQL to Oracle SQL. Used for auto generated sql from MySQL workbench, covers lots of the basics should just be a case of converting using the tool then paste outputed sql into oracle.