DBE_SQL_UTIL.create_hint_sql_patch

create_hint_sql_patch is an interface function used to create an SQL patch for optimization and return whether the execution is successful.

Only the initial, sysadmin, opradmin, and monadmin users have the permission to invoke this interface.

Table 1 DBE_SQL_UTIL.create_hint_sql_patch input parameters and return values

Parameter	Type	Description
patch_name	IN name	Specifies the patch name.
unique_sql_id	IN bigint	Queries the global unique ID.
hint_string	IN text	Specifies the hint text.
description	IN text	Specifies the patch description. The default value is null.
enabled	IN bool	Determines whether the patch takes effect. The default value is true.