Convert Oracle functions to PostgreSQL

Proprietary

Replaces Oracle-specific functions with PostgreSQL equivalents.

org.openrewrite.sql.ConvertOracleFunctionsToPostgres
mod run . --recipe=org.openrewrite.sql.ConvertOracleFunctionsToPostgres

Install it once from Recipe actions, then run it on every repository under the current directory. New to the Moderne CLI? Set it up.

Recipe list

It runs these recipes, in this order.

  1. Change a SQL function name
  2. Change a SQL function name
  3. Change a SQL function name
  4. Change a SQL function name
  5. Replace a SQL function call
  6. Convert DECODE to CASE
  7. Convert TRUNC of a date to DATE_TRUNC
  8. Convert Oracle date format elements that PostgreSQL misreads
  9. Convert LISTAGG to STRING_AGG
  10. Replace a SQL function call
  11. Replace a SQL function call
  12. Replace a SQL function call
  13. Replace a SQL function call
  14. Replace a SQL function call
  15. Replace a SQL function call