Convert Oracle functions to PostgreSQL
ProprietaryReplaces Oracle-specific functions with PostgreSQL equivalents.
org. openrewrite. sql. ConvertOracleFunctionsToPostgresmod run . --recipe= org. openrewrite. sql. ConvertOracleFunctionsToPostgresInstall 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.
- Change a SQL function name
- Change a SQL function name
- Change a SQL function name
- Change a SQL function name
- Replace a SQL function call
- Convert
DECODEtoCASE - Convert
TRUNCof a date toDATE_TRUNC - Convert Oracle date format elements that PostgreSQL misreads
- Convert
LISTAGGtoSTRING_AGG - Replace a SQL function call
- Replace a SQL function call
- Replace a SQL function call
- Replace a SQL function call
- Replace a SQL function call
- Replace a SQL function call