© Ben Brumm 2019
Ben BrummBeginning Oracle SQL for Oracle Database 18chttps://doi.org/10.1007/978-1-4842-4430-2_22

22. Using functions in SQL

Ben Brumm1 
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?

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 ...

Get Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.