© Ben Brumm 2019Ben BrummBeginning Oracle SQL for Oracle Database 18chttps://doi.org/10.1007/978-1-4842-4430-2_22
22. Using functions in SQL
Melbourne, VIC, Australia
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?
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 ...