Oracle to DB2 Migration Compatibility

You can migrate your Oracle database to DB2 database. Read the below article for 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, date, time 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.