Procedures Vs Functions:
The subsequent table lists out the differences among procedures and functions
Viewing Procedures and Functions
Procedures and Functions are viewed using the Data_dictionary Views:
SELECT * FROM USER_SOURCE;
Dropping Subprograms
Subprograms when not needed can be dropped using Drop command.
Syntax:
DROP FUNCTION <function name>; DROP PROCEDURE <procedure name>;