The missing() function ascertains whether an optional parameter has been supplied to a procedure or function.
missing(parameter)
• parameter – The procedure or function parameter that will be checked.
A boolean. True indicates the parameter was not supplied. False indicates the parameter value was supplied.