Oracle Programing: Functions vs Procedures

Oracle Procedures and Functions can be thought of as subprograms where they can be created and saved within the database as database objects. The basic idea of a function is that it should only do computations (ex: generateId()), but not to change the DB state (no changing the data in tables). And the idea of a procedure is that it is a series of steps to change the DB state. Note that both these functions and procedures can be called or referred within the other blocks too.