State some Uses of function.

Below are few uses:

1. Function is written only once and can be used/called multiple times at multiple places such as procedure/ views etc. this saves further efforts and time

2. It helps in making the program modular and easy to understand

3. Functions are compiled once and there are cached before they are used.

4. It helps in improving the performance and efficiency of the database

5. We can break down the complex logic into smaller and simpler functions as it allows us to use function inside a function.

6. Functions are easier to understand and maintain.