Can you explain the difference between a function and a procedure in PL/SQL, and provide an example of when you would use each?

```html

Focusing on the keyword "PL/SQL," here is an SEO-friendly response to the interview question:

Difference between a function and a procedure in PL/SQL:

A function in PL/SQL is a named PL/SQL block that returns a value, while a procedure is a named PL/SQL block that performs an action or a set of actions without returning any value.

Example of when to use a function in PL/SQL:

When a specific computation needs to be executed that returns a single value as an output, like calculating the square root of a number or converting temperature from Celsius to Fahrenheit.

Example of when to use a procedure in PL/SQL:

When a sequence of statements needs to be executed for processing, like updating multiple records in a database table or sending notifications to users.

```