own functions in Oracle DB #en, #whatIlearned, #work

Sometimes you are allowed or even forced to use functions in Oracle table field. I stumble on this when I was in need to check validity of security check we had.

In this case I was in need to validate if passwords are correctly checked for given profile. One parameter of "PROFILE" objects is "PASSWORD_VERIFY_FUNCTION". By default, there is function given to you by Oracle, but you could change it (perhaps to "my_function").

To do this, there is function to create your own function (CREATE OR REPLACE FUNCTION function ...). 
But when you forgot source code of it, you could see it in this way.

SELECT text FROM user_source WHERE name='<function_name>';

Easy and simple. For any function.
And that's all for today.