Oracle to DB2 Migration Compatibility

  • DB2 supports NUMBER, VARCHAR2, VARRAY of Oracle. Similarly, several Oracle proprietary SQL statements such as CONNECT BY, ROWNUM, and more are also supported in DB2.
  • Many of Oracle’s conversion and formatting functions, datetime arithmetic functions, string manipulation functions, and other functions are supported in DB2. The same applies to packages, built-in packages, and SQL*PLus scripts.



Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.

One thought

Comments are closed.