To prod your creativity and get you started, here are a number of examples of the ways stored functions in SQL can change the way you build Oracle-based systems. 17.8.1 Encapsulating Calculations In just about any and every application, you will need to perform the same calculations over and over again.