This article will help you to understand how to create a user defined function. It’s also known as stored function or user function. 1 – User defined functions are similar to procedures. The only difference is that function always returns a value. 2 – User defined functions can be used as a part of an SQL expression. Note: Oracle SQL does not support calling of functions with Boolean parameters or returns.