Source
How to utilize current user function with email-formatted user names
ISSUE: The system function CURRENT_USER when used in a security policy may not work as expected if user names are in email format (include embedded @).
Oracle - Custom UDFsOracle - INTERVAL UDFs
This custom UDF is added to avoid runtime exceptions caused by format differences when casting strings to DATE, inside procedures and functions. Custom UDF overloads CAST_DATE_UDF(datestr) It creates a DATE from a STRING.