Yes you can write PL/SQL Functions on Oracle Fusion Cloud Applications
Starting with Oracle 12c, a powerful new enhancement lets you define PL/SQL functions and procedures directly inside a SQL query’s WITH clause.
View details Articles
October 7, 2023