Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with BUILT-IN SQL FUNCTIONS

Issue 5584: The function %s depends on the time zone setting

Review the transformed code, and set the time zone manually if necessary.

Issue 5340: PostgreSQL doesn't support the %s function

You have SQL code that uses an Oracle function that PostgreSQL doesn't support. Re-write the code to either use an alternative function or create a user-defined function instead. Some of the functions that are not supported are as follows:

  • NANVL

  • NLS_LOWER

  • NLS_UPPER

  • SYS_CONTEXT

Issue 5271: The Oracle GREATEST function and PostgreSQL GREATEST function might give different results

Review your transformed code and modify it to change the argument's type if necessary.

Issue 5272: The Oracle LEAST function and PostgreSQL LEAST function might give different results

Review your transformed code and modify it to change the argument's type if necessary.

Issue 5579: The second parameter of %s function can be processed incorrectly

Review your transformed code and modify it if necessary.