SQL_TRANSPILER
SQL_TRANSPILER enables or disables the SQL Transpiler.
| Property | Description |
|---|---|
| Parameter type | String |
| Syntax | SQL_TRANSPILER = { ON | OFF } |
| Default value | OFF |
| Modifiable | ALTER SESSION, ALTER SYSTEM |
| Modifiable in a PDB | Yes |
| Basic | No |
| Oracle RAC | Different instances can use different values. |
When this parameter is set to ON, the SQL Transpiler feature is enabled and PL/SQL functions are automatically transpiled into SQL expressions whenever possible, without user intervention. When this parameter is set to OFF, the SQL Transpiler feature is disabled.
Note: This parameter is available starting with Oracle AI Database 26ai.