Find SQL function
Recipe ID
org.openrewrite.sql.search.FindFunctionArtifact
org.openrewrite.recipe:rewrite-sqlFind SQL functions by name.
Usage
You’ll need the Moderne CLI configured before running the command below.
mod run . --recipe org.openrewrite.sql.search.FindFunction --recipe-option "functionName=nvl"If the recipe isn’t available locally, install it with:
mod config recipes jar install org.openrewrite.recipe:rewrite-sql:2.14.1Options
| Name | Type | Description |
|---|---|---|
functionNamerequired | String | The name of the function to find, case insensitive. Supports glob. e.g. nvl |
Data tables
Structured output this recipe can produce.
- SQL queriesShows matching SQL queries.
org.openrewrite.sql.table.DatabaseQueries - SQL functions in useShows matching SQL functions and the queries that contain them.
org.openrewrite.sql.table.DatabaseFunctions - Source files that had resultsSource files that were modified by the recipe run.
org.openrewrite.table.SourcesFileResults - Source files that had search resultsSearch results that were found during the recipe run.
org.openrewrite.table.SearchResults - Source files that errored on a recipeThe details of all errors produced by a recipe run.
org.openrewrite.table.SourcesFileErrors - Recipe performanceStatistics used in analyzing the performance of recipes.
org.openrewrite.table.RecipeRunStats