Oracle D2K Developer Interview Questions and Answers

A procedure is a set of instructions that performs a specific task. Functions return a value, while procedures do not.

• Procedures are used to perform a specific task and do not return a value

• Functions return a value and can be used in expressions

• Procedures can have input and output parameters

• Functions can be called from within a procedure

• Example: A procedure to update a customer's address in a database

• Example: A function to calculate the average of a set of numbers