Ora2Pg Migration – NULL & Empty Oracle vs Postgres

There is a detailed explanation of this difference here. There is no static analyser tool going to check and help fixing those in advance. We end up checking such empty string only with the help of testing, going back to code to fix them.

In short, keep following in mind,

  1. Oracle considers Empty String(”) and NULL as null
  2. PG considers Empty String as Empty String and NULL as null.

Leave a Reply

Your email address will not be published.

WP2Social Auto Publish Powered By : XYZScripts.com