Chapter 3. Character, Number, and Miscellaneous Functions

Functions are a useful part of the SQL language. They can transform data in a way that is different from the way it is stored in a database. A function is a type of formula whose result is one of two things: either a transformation, such as changing the name of a student to uppercase letters, or information, such as the length of a word in a column. Most functions share similar characteristics, including a name, and typically at least one input parameter, also called argument, inside a pair of matching parentheses:


All functions in this ...

Get Oracle® SQL by Example, Third Edition now with O’Reilly online learning.

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