(Difference between function and procedure 1 Function has a return value, but the process does not
2. the function is called in the expression, and the procedure is used as the statement of the pl/sql program
Procedures and functions are stored in the database in compiled form. Functions can have no parameters or multiple parameters with return values. process
There are zero or more parameters and no return value. Both functions and procedures can receive or return zero or more values through a parameter list.
The main difference is not in the return values, but in the way they are called. Procedures are called independent execution statements, and functions are called valid expressions.)