Question

What is procedure? Explain different types of
procedures with example. Write difference
between procedure and function​

Answer 1

Procedure Function

Used mainly to a execute certain process Used mainly to perform some calculation

Cannot call in SELECT statement A Function that contains no DML statements can be called in SELECT statement

Use OUT parameter to return the value Use RETURN to return the value