I am looking for a tool/utility that can be used by developers to convert the DB2 Code to Oracle, as we're going through a migration effort. I thought I was lucky to see SQL Developer had a utility just for that (Scratch Editor), but it doesn't seem to convert a simple DB2 statement:
select tabschema, tabname, colname, typename, length
from syscat.columns
I get an error -
/**SQLDEV:FAILED TO TRANSLATE
select tabschema, tabname, colname, typename, length
**/
/**SQLDEV:FAILED TO TRANSLATE
from syscat.columns
**/
Is anyone aware of a tool/utility that converts DB2 SQL syntax to corresponding Oracle syntax? Does SQL Developer support this functionality?
Thanks
Raj