procedure can also 'return' a value by assigning an output parameter to it
Doesn't a procedure also 'return' a value by assigning an output parameter to it? I don't think this is so different from a function, technically speaking.
Thanks for reaching out.
Yes, technically they are not very different. The procedure allows SELECT as well as DML(INSERT/UPDATE/DELETE) statement in it, whereas functions allows only SELECT statement in it. Procedures cannot be utilized in a SELECT statement, whereas functions can be embedded in a SELECT statement.
Hope this helps.