There’s more to SQL than reading the data that’s stored in the table. You’ll often need to manipulate it or perform calculations on it. That’s where functions come in.
What is a Function?
A function is a piece of code stored in the database that allows you to perform a specific task that returns an output. There are three parts to a function:
The input, which is the data you provide to the function
The process, or what the function does
The output, which is the result of the function’s process
There are a lot of functions built into Oracle SQL to perform a lot of different ...
