The SQL used in query zones and Groovy scripts can be limited in relation to supported SQL functions that prevent performance issues or inappropriate access to the database through Oracle Utilities Cloud Service functions.

Oracle Utilities Cloud Service provides F1-SQLFunctionWhiteList, which is an allowlist implemented as a Managed Content object. This is a non-changeable allowlist that lists the supported and usable SQL functions. Oracle Utilities Cloud Service generates a runtime error when running an SQL function that is not included in the allowlist.