G-7460

🆓

Warning

Try to define your packaged/standalone function deterministic if appropriate.

Rule Details

Severity Level: Major
Quality Area: Reliability
Fixing times: 5 mins
Quick Fix | Local-medium
Database Support: OracleDB (v7.3.4 +)

Reason

A deterministic function (always return same result for identical parameters) which is defined to be deterministic will be executed once per different parameter within a SQL statement whereas if the function is not defined to be deterministic it is executed once per result row.

Example

Non-Compliant Example

create or replace package department_api is
   function name_by_id(in_department_id in departments.department_id%type)
      return departments.department_name%type;
end department_api;
/

Issues

Line	Column	Message
2	13	Define function name_by_id deterministic if appropriate.

Compliant Solution - ★★★★★

create or replace package department_api is
   function name_by_id(in_department_id in departments.department_id%type)
      return departments.department_name%type
      deterministic;
end department_api;
/

References

same as Trivadis G-7460