Hints

Hints

Converting your queries with Oracle style outer join (+) syntax to ANSI standard SQL at the Oracle side can save you a lot of time for the migration. You can use TOAD Query Builder to re-write these using the proper ANSI syntax, see: http://www.toadworld.com/products/toad-for-oracle/f/10/t/9518.aspx

There's also an alternative with SQL Developer Data Modeler, see http://www.thatjeffsmith.com/archive/2012/01/sql-developer-data-modeler-quick-tip-use-oracle-join-syntax-or-ansi/

Toad is also able to rewrite the native Oracle DECODE() syntax into ANSI standard SQL CASE statement. You can find some slides about this in a presentation given at PgConf.RU: http://ora2pg.darold.net/slides/ora2pg\_the\_hard\_way.pdf