Any tool for SQL converstion from Informix to Oracle ?



We are planning to port a huge application from Informix to Oracle and
it has got tons of SQL statements that need to be converted to make
them Oracle compliant.
We looked at Oracle migration work bench tool but it performs only DDL
conversion.
Is there any good tool out there to convert Informix SQL statements to
Oracle ?
-Thanks
.



Relevant Pages

  • Re: select * from (select * from bob) and other easy stuff
    ... I had a friend who had just gone through an Oracle demo ... Byte, Text, Serial or Serial8 datatypes in collection types not ... It seems like Informix is going out of its way ... Maybe I can get the database re-designed to avoid the use of serials. ...
    (comp.databases.informix)
  • Re: Informix 10 vs Oracle 10g
    ... It is amazing that Oracle technology could have gone so wrong despite the amount of money they have as a company, and how they could not come up with a better engine--or why haven't they dumped the current engine and made a new one that is actually better than any other product. ... single person who uses Informix who doesn't wish that Informix and IBM were as effective at creating brand awareness for Informix as Oracle is. ... If there isn't a market for Informix, no matter how great it is, you are not going to sell Informix to anyone. ...
    (comp.databases.informix)
  • Re: select * from (select * from bob) and other easy stuff
    ... I had a friend who had just gone through an Oracle demo ... Byte, Text, Serial or Serial8 datatypes in collection types not ... It seems like Informix is going out of its way ... Maybe I can get the database re-designed to avoid the use of serials. ...
    (comp.databases.informix)
  • Re: As the markets tank... Some Benchmark Stuff to distract you
    ... Oracle I truly believe and were I to wake up one morning and feel ... When I am with IBM I don't alter ... Informix is even a product, much less that it's a database engine. ... I can remember having to say the same things about Informix even when they had market share much closer to Oracle's. ...
    (comp.databases.informix)
  • Re: current informix white papers ?
    ... and getting developers that know Oracle is supposedly easier. ... If he chooses to show the Oracle RAC features you may gain something, but if he goes the other way (show Informix lack of features) it will be awful, because his knowledge of the product is inexistent and his ability to search information about it is very weak... ... So after educating yourself on Oracle/Informix HA features you may want to find out what are the problems your development team find in Informix... ...
    (comp.databases.informix)