Q&A BY TAG 'User Defined Function'

I need to connect to an external system in a User Defined Function (UDF) for data processing and require the user to provide the password as one of the arguments in UDF. Is there a way to mask the password provided by the user?

UDF Password User Defined Function

I need to connect to an external system in an UDF. Is there a way to get the credentials of user querying UDF so that the same can be user to connect to an external system?

UDF Role and User Management User Defined Function

Is there a way to apply a restriction on UDF such that it can only be executed in a WHERE Clause, and not at any other place. For example, SELECT UDF(123) FROM DUAL(); ---> It should be invalid SELECT * FROM <TableName> WHERE UDF(COLUMN1) = ...

UDF WHERE CONDITIONS User Defined Function